How do you use SUM IF in Power BI with an example?

By /

SUM IF is a function in Power BI that allows you to add up values in a specific column based on a certain condition. To use it, you need to specify the criteria or condition that you want to meet and the range of values to be added. For example, if you have a dataset of sales records and want to find the total sales for a specific product, you can use SUM IF to add up the sales column only for that product. This function is useful for creating customized reports and analyzing data based on specific criteria.

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 .

Additional Resources

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

x

Related terms:

  1. What is the difference between SUM and SUMX in Power BI?
  2. How Can I Calculate the Sum Using a Filter in Power BI?
  3. How do you calculate the sum in Power BI with an example?
  4. Is there a way to sum the values between two dates in excel with a formula in VBA?
  5. How to Calculate a Cumulative Sum in SAS (With Example)
  6. How Do I Calculate Sum of Squares in ANOVA (With Example)?
  7. How do I Sum Every Nth Row in Google Sheets (With Examples)
  8. How to Sum Values by Category in Excel?
  9. How do I Sum Columns Based on a Condition in R
  10. How to Sum Columns Based on a Condition