Wrong column total for if statement

Question

Hi -&nbsp;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.&nbsp;&nbsp;GreaterThan300Over60Days = IF([TotOver60] &gt;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] &gt;300, [TotOver60], 0)&nbsp;The individual lines are showing the information I wanted but the subtotal should be different than the TotOver60.&nbsp;&nbsp;Please let me know how I can get the total I'm looking for and if you need any other info.&nbsp;Thank you!&nbsp;

anonymous · Accepted Answer

Hey&nbsp;melaniemdavis&nbsp;&nbsp;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:&nbsp;https://community.powerbi.com/t5/Desktop/Matrix-Table-Total-Row-not-calculating-right-totals/td-p/442550&nbsp;Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] &gt;300, [TotOver60])"

Forum Discussion

Wrong column total for if statement

2 Replies

Related content

New Column with IF STATEMENT

wrong measure total including if statement

IF statement in custom column

If OR statement - what am i doing wrong?

Union - Wrong columns