Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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:
Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"
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
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:
Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
124 | |
76 | |
74 | |
58 | |
48 |
User | Count |
---|---|
165 | |
83 | |
68 | |
67 | |
55 |