Reducing model size in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sample product data with IDs, names, categories, and prices. This data is used to demonstrate reducing model size by removing unnecessary columns and filtering.

Cell	Value
A1	ProductID
B1	ProductName
C1	Category
D1	Price
A2	101
B2	Chair
C2	Furniture
D2	50
A3	102
B3	Table
C3	Furniture
D3	150
A4	103
B4	Pen
C4	Stationery
D4	2
A5	104
B5	Notebook
C5	Stationery
D5	5

Formula Trace

SUMX(FILTER(Products, Products[Category] = "Furniture"), Products[Price])

Step 1: FILTER(Products, Products[Category] = "Furniture")

Step 2: SUMX(filtered_table, filtered_table[Price])

Step 3: 200

Cell Reference Map

   A       B           C           D
1 ProductID ProductName Category    Price
2 101       Chair       Furniture   50
3 102       Table       Furniture   150
4 103       Pen         Stationery  2
5 104       Notebook    Stationery  5

Arrows point from Category and Price columns to the FILTER and SUMX functions.

The formula uses the Category column to filter rows and the Price column to sum values.

Result

   E
1 TotalFurniturePrice
2 200

The result shows the total price of products in the Furniture category, which is 200.

Sheet Trace Quiz - 3 Questions

What does the FILTER function do in this formula?

A Removes the Price column

B Keeps only rows where Category is Furniture

C Adds all prices together

D Changes product names

Key Result

FILTER narrows rows by condition; SUMX sums values over filtered rows.