DAX practice: Selective Removal with ALLEXCEPT & ALLSELECTED

Chapter 13 · 3 questions · included in full access

Question 1 · medium
Year total on every month
Write Year Total: sales across all months in the year, using ALLEXCEPT to keep the year filter.
Solve it in your browser
Question 2 · hard
Respect the slicer
Write Share of Selection: divide [Total Sales] by sales of all products selected in the visual (use ALLSELECTED).
Solve it in your browser
Question 3 · medium
Segment total
Write Segment Total: sales keeping the Customer Segment filter but clearing individual Customer filters.
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.

Year total on every month