cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Wrong column total for if statement

Hi -

I have been reading through the different solutions for showing the expected total in a table for an if statement but haven't been able to apply it to my particular report. Possibly because I have measures created from other measures.

GreaterThan300Over60Days = IF([TotOver60] >300, [TotOver60], 0)

The right two columns are my issue. Started with far right column and only wanted to show lines over \$300. I used this if statement.

GreaterThan300Over60Days = IF([TotOver60] >300, [TotOver60], 0)

The individual lines are showing the information I wanted but the subtotal should be different than the TotOver60.

Please let me know how I can get the total I'm looking for and if you need any other info.

Thank you!

1 ACCEPTED SOLUTION
Solution Sage

You'll want to use a SUMX formula instead of (or in addition to) an IF to get the total to calculate correctly. Check out the link below:

https://community.powerbi.com/t5/Desktop/Matrix-Table-Total-Row-not-calculating-right-totals/td-p/44...

Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"

2 REPLIES 2
Community Support

HI @melaniemdavis,

I'd like to suggest you take a look at following blog about measure total level calculation:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Solution Sage

You'll want to use a SUMX formula instead of (or in addition to) an IF to get the total to calculate correctly. Check out the link below:

https://community.powerbi.com/t5/Desktop/Matrix-Table-Total-Row-not-calculating-right-totals/td-p/44...

Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors