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, 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 -
@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
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |