Optimizing DAX queries in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data for three products with their sales amounts.

Cell	Value
A1	Product
B1	Sales
A2	Apple
B2	100
A3	Banana
B3	150
A4	Cherry
B4	200

Formula Trace

SUMX(FILTER('Table', 'Table'[Sales] > 100), 'Table'[Sales])

Step 1: FILTER('Table', 'Table'[Sales] > 100)

Step 2: SUMX([Banana, 150], [Cherry, 200], 'Table'[Sales])

Step 3: 150 + 200

Cell Reference Map

    A       B
1 Product  Sales
2 Apple    100
3 Banana   150  <-- Filtered in
4 Cherry   200  <-- Filtered in

The formula uses the Sales column (B2:B4) to filter and sum values greater than 100.

Result

    A       B       C
1 Product  Sales   Result
2 Apple    100     
3 Banana   150     
4 Cherry   200     350

The result 350 appears next to the data, showing the sum of sales greater than 100.

Sheet Trace Quiz - 3 Questions

Which rows does the FILTER function keep?

A Rows where Sales < 100

B Rows where Sales > 100

C All rows

D No rows

Key Result

Use FILTER to reduce rows before aggregation with SUMX for better performance.