Calculated tables in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table lists products with their IDs, names, and categories.

Cell	Value
A1	ProductID
B1	ProductName
C1	Category
A2	1
B2	Apple
C2	Fruit
A3	2
B3	Carrot
C3	Vegetable
A4	3
B4	Banana
C4	Fruit
A5	4
B5	Broccoli
C5	Vegetable

Formula Trace

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

Step 1: Products[Category]

Step 2: Products[Category] = "Fruit"

Step 3: FILTER(Products, [TRUE, FALSE, TRUE, FALSE])

Cell Reference Map

    A          B           C
1 ProductID ProductName  Category
2    1       Apple       Fruit  <-- included
3    2       Carrot     Vegetable
4    3       Banana      Fruit  <-- included
5    4       Broccoli   Vegetable

The formula filters rows based on the Category column values in column C.

Result

    A          B           C
1 ProductID ProductName  Category
2    1       Apple       Fruit
4    3       Banana      Fruit

The calculated table shows only products where Category is 'Fruit'.

Sheet Trace Quiz - 3 Questions

What does the FILTER function do in this formula?

A Keeps only rows where Category is 'Fruit'

B Deletes rows where Category is 'Fruit'

C Changes all categories to 'Fruit'

D Adds a new column named 'Fruit'

Key Result

FILTER(table, condition) returns a table with rows where condition is TRUE