DAX practice: CALCULATE & Boolean Overwrites
Chapter 9 · 4 questions · included in full access
Question 1 · easy
Filters replace filters
Solve it in your browserA visual has Products[Category] on its rows. A measure uses
CALCULATE([Total Sales], Products[Category] = "Sheets"). What appears on the Profiles row?Question 2 · easy
Sheet sales
Solve it in your browserWrite Sheets Sales: total sales for the Sheets category, shown by region.
Question 3 · easy
North sales
Solve it in your browserWrite North Sales: total sales for the North region, shown by category.
Question 4 · medium
Discounted sales
Solve it in your browserWrite Discounted Sales: total sales on orders where Discount is greater than 0.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing