Hard mode - changing total sum of measure

[Anonymous]

/* 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. 

PBIX 

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

[Anonymous]

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 

PBIX 

Please let me know 

Thank you again for your help 

[daxer-almighty]

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.

[Anonymous]

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

[Greg_Deckler]

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