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.
Hello,
I'm facing strange problems when calculating total values.
I have a measure which calculate the row values right, but the total is null.
When i add a new measure, the total value is right, but the row values are null.
Another measure, right row values but a strange total value
And so on...
I don't see what is going wrong? I hope you can help me!
Measures are
Solved! Go to Solution.
Hi,
Does this measure work?
=IF(HASONEVALUE(Artikelen[Artikelgroep]),[ProductMix1],SUMX(SUMMARIZE(VALUES(Artikelen[Artikelgroep]),Artikelen[Artikelgroep],"ABCD",[ProductMix1]),[ABCD]))
Hi,
Does this measure work?
=IF(HASONEVALUE(Artikelen[Artikelgroep]),[ProductMix1],SUMX(SUMMARIZE(VALUES(Artikelen[Artikelgroep]),Artikelen[Artikelgroep],"ABCD",[ProductMix1]),[ABCD]))
Unbelievable! This one works! Really thank you!
Nevertheless, i find it really hard to find the right way how Power Bi calculates the different totals.
Thank you again!
Kind regards Marcel
You are welcome.
Hi @marsclone ,
could you post your calculation of the measures.
[Tonnen CY %]
[Tonnen LY %]
[Tonnen CY All]
[Prijs LY]
Please give Kudos for support.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |