SUM DAX Function in Power BI

In this exercise, we will learn about the SUM DAX function in Power BI. The SUM DAX function adds all the numbers in the given column.

DAX Syntax SUM([column])

Note: The SUM function only accepts column reference as the argument. If we want to filter the values that we are summing, we can use the SUMX function and specify an expression to sum over.

Example: Create a measure with name “Total marks of 10th all students”.

To create a measure, in the Table Tools contextual ribbon, from inside the Calculations group, select New measure.

In the formula bar, enter the following measure definition and then press Enter.

DAX

The above formula creates a measure named “Total marks of 10th”. It uses the SUM DAX function to sum the values of the 10th Marks column in the Sheet1 table. In the Fields pane, measures are shown with the calculator icon.

The output of the above measure can be shown in a Card visual as shown in the image below:

It returns the sum of all values available in the column, but subject to the visual filters like column value, row value, and any specific filter that we apply manually.