Table of contents
TOC
Collapse the table of content
Expand the table of content

SUM Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

Adds all the numbers in a column.

Syntax

SUM(<column>)  

Parameters

TermDefinition
columnThe column that contains the numbers to sum.

Return Value

A decimal number.

Remarks

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.

Example

The following example adds all the numbers that are contained in the column, Amt, from the table, Sales.

=SUM(Sales[Amt])  

See Also

SUMX Function (DAX)
Statistical Functions (DAX)

© 2018 Microsoft