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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Not applicable

Hard mode - changing total sum of measure

/* EDIT : created the PBIX file and reformulate the description */


Hi Everyone, I'm new to Power BI & Dax, and I'm struggling with one Dax Formula 


here is the data structure : 




with that formula : 



old_cogs = SUMX('Product',[Fin COGS per 9L BL] *[9L Cs])



I got things right, because the total is the sum of all my rows, and my rows respect my formula : [Fin COGS per 9L BL] *[9L Cs]





But once I remove the column Product SKU, I got the result below which is not correct : 

Yeah In fact, once I removed the SKU product dimensions, the calculation should go back to normal, which is : [Fin COGS per 9L BL] *[9L Cs]

Why I still have the sum of each product value ? 




I also join the PBIX file. 



Thanks in advance for people that will try to help me 🙂 

Not applicable

Thank you @Greg_Deckler @daxer-almighty @Anonymous for your help,


I also updated the first post in order to give example 


I could create a sample data with offline PBI 



Please let me know 

Thank you again for your help 


Solution Sage
Solution Sage

Please create a small file with sample data (without any connections since people can't obviously connect to any sources you have) and demonstrate the issue in there. Much more effective and you'll get an answer quicker.

Not applicable

Hello @Anonymous 
While opening the PBIX it's asking for a data connection. Can you please provide some sample data in table format?

Super User
Super User

@Anonymous Downloaded PBIX but seems like it is a DirectQuery model so need credentials. But this looks like a measure totals problem. Very common. See my post about it here:

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors