Back to Roadmap
Level 2 — Working With Filters+75 XP
Lesson 3
3. Removing Filters with ALL
Clearing slicers and filters to calculate market share and grand totals.
The Concept
ALL returns all rows in a table or column, ignoring any active filters.
Example DAX:
All Customers Revenue =
CALCULATE(
SUM(Sales[Revenue]),
ALL(Customers)
)ALL is most commonly used inside CALCULATE to compute total denominator values for calculating percentage of total (% of parent / % of grand total).
Try It Yourself
Write a measure 'Grand Total Sales' that calculates total revenue ignoring all filters on the Sales table using ALL.
fx
[fx]Removing Filters with ALL=
Loading DAX Formula Studio...
Type [ for fields