SUM Function (DAX)
Adds all the numbers in a column.
SUM(<column>)
Parameters
| Term | Definition |
|---|---|
| column | The column that contains the numbers to sum. |
A decimal number.
If any rows contain non-numeric values, blanks are returned.
If you want to filter the values that you are summing, you can use the SUMX function and specify an expression to sum over.
The following example adds all the numbers that are contained in the column, Amt, from the table, Sales.
=SUM(Sales[Amt])
Community Additions
ADD
Show: