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