CALCULATE with multiple 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
A6	Orange
B6	Fruit
C6	130

Formula Trace

CALCULATE(SUM(Sales), Category = "Fruit", Sales > 120)

Step 1: SUM(Sales)

Step 2: Category = "Fruit" filter

Step 3: Sales > 120 filter

Step 4: Combined filters: Category = "Fruit" AND Sales > 120

Step 5: SUM(Sales) with filters

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
6 Orange   Fruit      130

Filters used: B2:B6 (Category), C2:C6 (Sales)

The formula filters rows based on Category column (B) and Sales column (C).

Result

    A        B          C          D
1 Product  Category   Sales      Result
2 Apple    Fruit      100        
3 Banana   Fruit      150        
4 Carrot   Vegetable  200        
5 Broccoli Vegetable  120        
6 Orange   Fruit      130        
7                      Total: 280

The result 280 is the sum of Sales for products in the Fruit category with Sales greater than 120.

Sheet Trace Quiz - 3 Questions

Which rows are included after applying the filter Category = "Fruit"?

A Carrot, Broccoli

B Apple, Banana, Orange

C Banana, Carrot, Orange

D All rows

Key Result

CALCULATE(expression, filter1, filter2, ...) applies multiple filters combined with AND to the expression.