DAX practice: Dimension Iteration with VALUES
Chapter 8 · 3 questions · included in full access
Question 1 · medium
Average month
Solve it in your browserWrite Avg Monthly Sales: average [Total Sales] across the months visible in each year.
Question 2 · medium
Avg sales per rep
Solve it in your browserWrite Avg Sales per Rep: iterate over distinct reps using VALUES and average [Total Sales].
Question 3 · easy
Active categories
Solve it in your browserWrite Active Categories: count the distinct categories sold in each year using VALUES.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing