topic Re: Total does not show up correctly while using SUMX and SUMMARIZE (in Matrix) in DAX Commands and Tips

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

JustinDoh1 — Sun, 18 Sep 2022 15:36:27 GMT

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!

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

Greg_Deckler — Mon, 23 Aug 2021 13:17:35 GMT

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

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

JustinDoh1 — Mon, 23 Aug 2021 16:51:48 GMT

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 🙂