Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
JustinDoh1
Post Prodigy
Post Prodigy

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

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.

JustinDoh1_0-1629723305044.png

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".

JustinDoh1_2-1629723581116.png

So, the expected output is 1 = (0 + 1) for the total in this case.

 

Thanks for your help again!

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
JustinDoh1
Post Prodigy
Post Prodigy

@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
Super User
Super User

@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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.