Back to Roadmap
Level 1 — DAX Foundations+50 XP
Lesson 3
3. The SUM Function
Summing numerical column values efficiently.
The Concept
SUM adds all the numbers in a single column. It respects all active filters on the report page.
Example DAX:
Total Cost = SUM(Sales[Cost])
SUM accepts exactly one parameter: a column reference. You cannot write expressions like SUM(A * B) inside SUM — for that, you will use SUMX later.
Try It Yourself
Create a measure for 'Total Cost' using SUM on the Cost column of the Sales table.
fx
[fx]The SUM Function=
Loading DAX Formula Studio...
Type [ for fields