I am sharing my Pbix file here.
I am trying to show the total correctly in the Matrix, but whever the choice inside SWITCH is met, it would not show the Total correctly.
I have an illustration on the bottom.
I have a measure called "Step_0823" that goes thru different output option(s) inside SWITCH, and then if none of them would be met, it would display the output of variable "Step1".
So, the expected output is 1 = (0 + 1) for the total in this case.
Thanks for your help again!
Solved! Go to Solution.
@JustinDoh1 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
@Greg_Deckler You did it again. Thank you so much! It works as expected. I am seeing some performance issue (slow with retrieving data) with my measure. I will investigate more what can be done to go faster, but for now, I think I am happy 🙂
@JustinDoh1 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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!