Goal: Calculate Total Sales by multiplying Price × Quantity for each row.
Watch how the iterator works.
Ready to calculate...
💻 DAX Formula
-- Scenario 1: The Wrong Way
MEASURE Sales = SUM( Sales[Price] * Sales[Qty] )
-- ⚠️ ERROR: SUM only accepts one column!
-- Scenario 2: The Iterator Way (SUMX)
MEASURE Sales =
SUMX (
Sales, // 1. Iterate row-by-row
Sales[Price] * Sales[Qty] // 2. Calculate row context
) // 3. Sum the results