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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
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 : 

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
Anonymous
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 

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.

Anonymous
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?

Greg_Deckler
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: 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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors