ALL function for removing filters in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data for products with their categories and sales amounts.

Cell	Value
A1	Product
B1	Category
C1	Sales
A2	Apple
B2	Fruit
C2	100
A3	Banana
B3	Fruit
C3	150
A4	Carrot
B4	Vegetable
C4	200
A5	Broccoli
B5	Vegetable
C5	120

Formula Trace

Total Sales All Categories = CALCULATE(SUM(Sales[Sales]), ALL(Sales[Category]))

Step 1: SUM(Sales[Sales])

Step 2: ALL(Sales[Category])

Step 3: CALCULATE(SUM(Sales[Sales]), ALL(Sales[Category]))

Cell Reference Map

    A         B          C
1 Product   Category   Sales
2 Apple     Fruit      100
3 Banana    Fruit      150
4 Carrot    Vegetable  200
5 Broccoli  Vegetable  120

Filters removed on column B (Category)

The formula removes filters on the Category column (B) to sum all sales regardless of category.

Result

    D
1 Total Sales All Categories
2 570

The measure shows total sales 570, summing all products ignoring any category filter.

Sheet Trace Quiz - 3 Questions

What does the ALL function do in this formula?

A Removes filters on the Category column

B Filters only Fruit category

C Sums sales only for filtered categories

D Adds a new filter on Category

Key Result

ALL removes filters on specified columns to calculate over entire data ignoring those filters.