DAX practice: Removing Filters: ALL & REMOVEFILTERS
Chapter 12 · 5 questions · included in full access
Question 1 · easy
What ALL does
Solve it in your browserWhat does
CALCULATE([Total Sales], ALL(Products))do when evaluated on a category row?Question 2 · easy
Total on every row
Solve it in your browserWrite All Product Sales: total sales with all filters on Products removed.
Question 3 · medium
Percent of total
Solve it in your browserWrite % of Total: divide [Total Sales] by total sales across all products.
Question 4 · medium
Region share
Solve it in your browserWrite Region Share: divide [Total Sales] by sales across all reps using REMOVEFILTERS.
Question 5 · hard
Share of category
Solve it in your browserWrite % of Category: divide [Total Sales] by sales of that product's category (clear filters from Products[Product]).
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing