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
kirkademidov
Frequent Visitor

Sum Average measure issue

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:

  1. Calc : score per question
  2. Calc by model : total score of all questions in the model
  3. Calc by model percentage :    Calc / Calc by model
  4. Average score : average score of all transactions in the table (Type of measure : Average)
  5. Calc Total Score : Average score *  Calc by model percentage

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 🙂WhatsApp Image 2018-05-23 at 18.30.06.jpeg

 

 

 

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

Check out my Matrix Measure Total Triple Threat Rock & Roll measure (MM3TR&R):

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...


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

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!

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.