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

Sample Data

Sales data for different fruits.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	150
A4	Cherries
B4	200
A5	Dates
B5	50

Formula Trace

CALCULATE(SUM(Sales), Product IN {"Apples", "Bananas"})

Step 1: SUM(Sales)

Step 2: Product IN {"Apples", "Bananas"}

Step 3: CALCULATE(SUM(Sales), Filter)

Cell Reference Map

     A        B
  +-------+-------+
1 |Product| Sales |
  +-------+-------+
2 |Apples |  100  | <-- Included by filter
3 |Bananas|  150  | <-- Included by filter
4 |Cherries| 200  | <-- Excluded by filter
5 |Dates  |  50   | <-- Excluded by filter
  +-------+-------+

The filter uses the Product column to include only Apples and Bananas rows for the calculation.

Result

     A        B
  +-------+-------+
1 |Product| Sales |
  +-------+-------+
2 |Apples |  100  |
3 |Bananas|  150  |
  +-------+-------+

Total Sales (Filtered) = 250

The visual shows only Apples and Bananas sales summed to 250 after applying the visual-level filter.

Sheet Trace Quiz - 3 Questions

What does the filter 'Product IN {"Apples", "Bananas"}' do?

A Includes only Apples and Bananas rows

B Includes all products except Apples and Bananas

C Includes only Cherries and Dates

D Includes all products

Key Result

CALCULATE(SUM(Column), FilterCondition) applies a filter to sum only selected rows.