Forum Discussion
'What If' Commission Help
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
Thanks for your reply Greg_Deckler.
Turning off the Total Row isn't much of an option so I'm going to try the HasOneFilter function. Where do you recommend that I put it?
R
Did you look at the Quick Measure? That should be your guide for how to accomplish what you are trying to do.
I've been looking at it for 30 minutes now! And to be honest, I'm not sure if I need to Summarize every Variable in my measure or just the HasOneValue Function in the Return Statement. But I'm going to try the easiest thing first and go from there! I'll report back soon.
R
Umm... no. I'm kinda lost on how to handle the Summarize and/or the HasOneValue. Can you help me walk through my measure on where I need to focus?
Thanks!
R