Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
User | Count |
---|---|
17 | |
16 | |
14 | |
13 | |
12 |
User | Count |
---|---|
17 | |
14 | |
12 | |
10 | |
9 |