TechNet
Export (0) Print
Expand All

SUM Function (DAX)

 

Adds all the numbers in a column.

SUM(<column>)  

Parameters

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

=SUM(Sales[Amt])  

SUMX Function (DAX)
Statistical Functions (DAX)

Community Additions

Show:
© 2016 Microsoft