cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
benjaminlenglet
Frequent Visitor

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 : 

benjaminlenglet_1-1620219943889.png

 

 

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]

 

benjaminlenglet_0-1620219739724.png

 

 

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 ? 

 

benjaminlenglet_2-1620220015479.png

 

I also join the PBIX file. 

PBIX 

 

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

4 REPLIES 4
benjaminlenglet
Frequent Visitor

Thank you @Greg_Deckler @daxer-almighty @TarunSharma 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
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.

TarunSharma
Responsive Resident
Responsive Resident

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

Greg_Deckler
Super User IV
Super User IV

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

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors