Wrong column total for if statement

[melaniemdavis]

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!

[v-shex-msft]

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

[Tad17 · Accepted solution]

Hey @melaniemdavis 

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])"