Report-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	1000
A3	South
B3	1500
A4	East
B4	1200
A5	West
B5	1300

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 | 1000  |
3 | South | 1500  |
4 | East  | 1200  |
5 | West  | 1300  |

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

The formula filters the data to only include rows where Region is 'North' before summing Sales.

Result

    A       B
1 |Region | Sales |
2 | North | 1000  |

Result cell shows: 1000

The final result shows total sales for the North region only, which is 1000.

Sheet Trace Quiz - 3 Questions

What does the filter 'Region = "North"' do in the formula?

A It sums all sales regardless of region

B It limits the data to only rows where Region is North

C It excludes the North region from the sum

D It multiplies sales by North

Key Result

CALCULATE with filter applies condition first, then aggregates filtered data.