Total does not show up correctly while using SUMX and SUMMARIZE (in Matrix)

[JustinDoh1]

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!

[JustinDoh1]

@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 🙂

[Greg_Deckler · Accepted 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