Export (0) Print
Expand All

SUM Function (DAX)

Adds all the numbers in a column.


SUM(<column>)

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])
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft