SUM

Applies to: Calculated column Calculated table Measure Visual calculation

Adds all the numbers in a column.

Syntax

SUM(<column>)  

Parameters

Term Definition
column The column that contains the numbers to sum.

Return value

A decimal number.

Remarks

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])  

SUMX