SUM Function (DAX)


Adds all the numbers in a column.



columnThe 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.


SUMX Function (DAX)
Statistical Functions (DAX)

Community Additions