How to Use SUM IF in Power BI (With Example)


You can use the following syntax in DAX to write a SUM IF function in Power BI:

Sum Points =
CALCULATE (
    SUM ( 'my_data'[Points] ),
    FILTER ( 'my_data', 'my_data'[Team] = EARLIER ( 'my_data'[Team] ) )
)

This particular formula creates a new column named Sum Points that contains the sum of values in the Points column for each unique value in the Team column in the table named my_data.

The following example shows how to use this formula in practice.

Example: How to Use SUM IF in Power BI

Suppose we have the following table in Power BI named my_data that contains information about various basketball players:

Suppose we would like to create a new column that shows the sum of points scored by players on each team.

To do so, click the Table tools tab, then click the New column icon:

Then type the following formula into the formula bar:

Sum Points =
CALCULATE (
    SUM ( 'my_data'[Points] ),
    FILTER ( 'my_data', 'my_data'[Team] = EARLIER ( 'my_data'[Team] ) )
)

A new column named Sum Points will be created that shows the sum of the points values for each team:

From the output we can see:

  • The sum of points value for players on the Mavs team is 75.
  • The sum of points value for players on the Rockets team is 48.
  • The sum of points value for players on the Spurs team is 65.
  • The sum of points value for players on the Hornets team is 31.

Note: You can find the complete documentation for the SUM function in Power BI here.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Calculate Average Value in Column
Power BI: How to Calculate Average and Ignore Zeros
Power BI: How to Calculate Average By Month

Leave a Reply

Your email address will not be published. Required fields are marked *