Filtering rows in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows products with their categories and sales amounts.

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

Formula Trace

FILTER(Table1, Table1[Category] = "Fruit")

Step 1: Check each row's Category value

Step 2: Compare each Category to "Fruit"

Step 3: Return rows where condition is TRUE

Cell Reference Map

    A         B          C
1 | Product | Category | Sales
2 | Apple   | Fruit    | 100  
3 | Carrot  | Vegetable| 50   
4 | Banana  | Fruit    | 80   
5 | Broccoli| Vegetable| 60   

Filter uses column B (Category) to check for "Fruit"

The formula checks the Category column (B2:B5) to filter rows where the value is 'Fruit'.

Result

    A       B       C
1 | Product | Category | Sales
2 | Apple   | Fruit    | 100  
4 | Banana  | Fruit    | 80   

The filtered table shows only rows where Category is 'Fruit', keeping Apple and Banana rows.

Sheet Trace Quiz - 3 Questions

Which rows are kept after filtering with FILTER(Table1, Table1[Category] = "Fruit")?

A Rows with Category 'Fruit' only

B Rows with Category 'Vegetable' only

C All rows

D No rows

Key Result

FILTER(table, condition) returns only rows where condition is TRUE