Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

SUM

Applies to: 👁 Image
Calculated column 👁 Image
Calculated table 👁 Image
Measure 👁 Image
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])

Related content


Feedback

Was this page helpful?

Additional resources