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.
Hi All,
I have a hierarchy with 5 levels: leaf level is question and above is Model level etc.
I have a calculated measure that presents the score of average
Description of the measures in the table:
As you can see when the measure is in the leaf level of question the calculation of Calc Total Score is good
but when the measure calc the level above (Model level) i get the value of 70 instead of 62.67 (24.88+37.79)
If someone can help me with dax function to sum it up correctly I'll be thanks 🙂
Check out my Matrix Measure Total Triple Threat Rock & Roll measure (MM3TR&R):
Thanks @Greg_Deckler ,
I can not see how to apply you solution in my case - I`m attaching my PBIX file to this post - may be you can help me with this?
Thanks A lot!
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |