SUMX Works Row by Row

Part of the DAX with CALCULATE section of Coddy's Power BI journey. Lesson 12 of 24.

SUMX(Table, expression) works out the expression on each row, then adds the results.

Gross Sales = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice])

Each row multiplies its own quantity and price. Nothing is stored.

Multiplying two SUMs is not the same: it multiplies totals.

Challenge

What would sales be at list price, before the member discount? Write Gross Sales: the sum of quantity times unit price, line by line. It is checked for each category.

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATE A Filter Replaces a Filter Several Filters at Once Keeping Filters Recap - Member Drink Sales

4DAX You Can Read

Variables with VAR Choosing with SWITCH SWITCH(TRUE()) for Ranges One Value or Many Rows or the Total Checking Copilot's DAX Recap - Sales by Price Band

2Removing Filters

ALL Removes Filters Percent of Total Removing One Filter Keep One Filter: ALLEXCEPT Share of What Is Shown Recap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by RowAVERAGEX and MAXX FILTER Picks Rows Measures Inside Iterators Ranking with RANKX Recap - Profit Without Columns