Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
So, I have a table where I see something like this:
Item | Revenue |
A | -10 |
B | 20 |
C | 40 |
I write a measure something like this:
Calculated Revenue = IF(SUM(Revenue) > 0, SUM(Revenue), 0)
What would my final table visual look like? Would the sum be 50 or 60? 60 is the sum of rows. 50 would be the value if I apply the measure on the total i.e (-10+20+40 > 0?, Yes, so 50). I am looking to ensure the value is 60 and not 50.
Item | Calculated Revenue |
A | 0 |
B | 20 |
C | 40 |
Total | 50/60 |
I am facing a scenario where the measure for rows in my table are either positive or 0 (because of certain conditionals) but the grandtotal shows up as 0.
Solved! Go to Solution.
@afaro You are not the first to wonder about this. Nor will you be the last. First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
@afaro You are not the first to wonder about this. Nor will you be the last. First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
20 | |
7 | |
6 | |
5 | |
5 |
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |