SUMX and iterators in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows products with their unit prices and quantities sold.

Cell	Value
A1	Product
B1	Price
C1	Quantity
A2	Apple
B2	2
C2	5
A3	Banana
B3	1
C3	10
A4	Cherry
B4	3
C4	7

Formula Trace

SUMX(Table, Table[Price] * Table[Quantity])

Step 1: Table[Price] * Table[Quantity] for Apple

Step 2: Table[Price] * Table[Quantity] for Banana

Step 3: Table[Price] * Table[Quantity] for Cherry

Step 4: SUM of all row results: 10 + 10 + 21

Cell Reference Map

    A       B       C
1 Product  Price  Quantity
2 Apple      2       5
3 Banana     1      10
4 Cherry     3       7

Formula uses columns B and C for multiplication in each row.

The formula references Price (B2:B4) and Quantity (C2:C4) columns for each product row.

Result

    A       B       C       D
1 Product  Price  Quantity  Total
2 Apple      2       5       10
3 Banana     1      10       10
4 Cherry     3       7       21
5                         SUMX Result: 41

The Total column shows the multiplication per row. The final SUMX result is 41, the sum of all totals.

Sheet Trace Quiz - 3 Questions

What does SUMX do in this formula?

A It sums Price and Quantity columns separately.

B It multiplies Price and Quantity for each row and then sums the results.

C It multiplies all Prices together and all Quantities together.

D It returns the maximum Price multiplied by maximum Quantity.

Key Result

SUMX iterates over each row, evaluates an expression, then sums all results.