SUM Function (DAX)

How does the SUM function (DAX) work?

The SUM function (DAX) adds all the numbers in a column.

SUM Formula Syntax

SUM(
     <column>
)

How do you use the SUM function?

This function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel.

Related Blog Posts

Related Support Forum Posts

Cumulative sum of a measure that creates another cumulative sum
SUM vs SUMX – What’s The Real Difference Between These DAX Measures
Grouped Summary

Considerations when using the SUM function

The SUM function uses the following arguments:

  1. Number1 (required argument) – This is the first item that we wish to sum.
  2. Number2 (required argument) – The second item that we wish to sum.
  3. Number3 (optional argument) – This is the third item that we wish to sum.

The function sums values supplied as arguments (up to 255 arguments). Arguments can be supplied as numbers, cell references, ranges, arrays, constants, and the results of other formulas or functions.

If you want to filter the values that you are summing, you can use the SUMX function and specify an expression to sum over.

Related Video Tutorials

Formula examples using the SUM function

=SUM(Sales[Amt])

=SUM(C5:C10)

=SUM(D6,D8,D10)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.