Stacked bar chart not aggregating correctly.

[JonBonesJones]

Hello, good morning everyone!

I'm completely stuck on a problem displaying data correctly on a stacked bar chart. My stacked bar chart follows the drill process of Exam > > Sub Exam > > User scores. The user scores and sub-exam scores all seem to be fine but the main exam scores only seem to show the users max score from the sub exams, rather than aggregating if that makes sense? 

The images below should sort of give an idea of everything

Main Exams

Sub Exams

User Scores for Sub Exams

The Sub Exam image is a reflection of the very top bar (63) but as you can see, it doesn't quite add up correctly. 

The measures I've created are to check scores from 0-100% and follow a similar formula of - 

10% = (CALCULATE(DISTINCTCOUNT(jobs[EmailID] ), Filter(jobs,jobs[ActivityTotalNew] >= 0.1 ) ) - [100%] - [90%] - [80%] - [70%] - [60%] - [50%] - [40%] - [30%] - [20%] )

or

70% = (CALCULATE(DISTINCTCOUNT(jobs[EmailID] ), Filter(jobs,jobs[ActivityTotalNew] >= 0.7 ) ) - [100%] - [90%] - [80%])

etc, upto 100%

And the measure I've used to add up the totals of the exams is ActivityTotalNew which is - 

ActivityTotalNew = (jobs[Exam1%]) + (jobs[Exam2%]) + (jobs[Exam3%]) + (jobs[Exam4%]) + (jobs[Exam5%])

The scores are all decimal and should add upto a score of 1 for 100% but it's just not quite working out somewhere and I'm completely at a little bit of a dead end 😔

If anyone had any ideas or pointers of how to get it all working correctly, I'll be more than grateful, I'm just completely stuck on trying to find a solution. I think it's due to the data not aggregating correctly but I'm not sure on how to fix it all. 

Thank you in advance for any help and if anyone has ay questions or needs more information, feel free to let me know and I'll try as much as I can to help! Thank you! 🙂

[Greg_Deckler]

@JonBonesJones First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

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

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8