Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
16 | |
10 | |
8 | |
8 | |
7 |