DAX practice: Dynamic Logic, Slicers & Ranking

Chapter 19 · 5 questions · included in full access

Question 1 · medium
Margin bands
Write Margin Band: 'High' if [Margin %] >= 0.4, 'Medium' if >= 0.3, otherwise 'Low'. Use SWITCH(TRUE()).
Solve it in your browser
Question 2 · medium
Region title
Write Region Title: 'Sales for ' concatenated with SELECTEDVALUE of Reps[Region], falling back to 'all regions'.
Solve it in your browser
Question 3 · medium
Blank the total
Write Avg per Order: compute DIVIDE([Total Sales], [Orders]), but only when HASONEVALUE(Reps[Rep]) is true.
Solve it in your browser
Question 4 · hard
Rank the reps
Write Rep Rank: rank sales reps by [Total Sales] using RANKX over ALL(Reps[Rep]).
Solve it in your browser
Question 5 · hard
Top product per region
Write Top Product: extract the top-selling product name using CONCATENATEX, TOPN, and VALUES.
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

Margin bands