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