Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
/* 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 🙂
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
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.
Hello @Anonymous
While opening the PBIX it's asking for a data connection. Can you please provide some sample data in table format?
@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
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |