Page-level filters in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data by region for a company.

Cell	Value
A1	Region
B1	Sales
A2	North
B2	100
A3	South
B3	150
A4	East
B4	200
A5	West
B5	120

Formula Trace

CALCULATE(SUM(Sales), Region = "North")

Step 1: SUM(Sales)

Step 2: Region = "North" filter applied

Step 3: SUM(Sales) with filter Region = "North"

Cell Reference Map

    A       B
1 |Region | Sales |
2 | North |  100 |
3 | South |  150 |
4 | East  |  200 |
5 | West  |  120 |

Filter applied on column A (Region) for value 'North'

The formula filters the data to only include rows where Region is 'North', then sums the Sales column.

Result

Page Filter: Region = North

| Region | Sales |
|--------|-------|
| North  |  100  |

Total Sales after filter: 100

The page-level filter limits the data to 'North' region only, so the total sales shown is 100.

Sheet Trace Quiz - 3 Questions

What does the formula CALCULATE(SUM(Sales), Region = "North") do?

A Filters sales for South region

B Sums sales for all regions

C Sums sales only for the North region

D Counts the number of sales entries

Key Result

CALCULATE(expression, filter) applies the filter first, then evaluates the expression on filtered data.