Forum Discussion
Calculating total value from a measure
Community ChampionJonBonesJones 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
This may also be what you are looking for:
This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.
Hi Greg! Thank you very much for your post! It's definitely helped give me a lot of ideas 🙂 The issue with the measures not adding as a Sum within a Table visualization is very annoying, although your explanation did help me understand it.
I'm currently trying to sort a workaround as a solution - My issues stem from a lot of my current data has had to be created from Measures, as the data I have on the backend isn't great, so it's difficult for me to reference Tables and Columns. It was mainly just trying to get a Total value, so I could create a card visual to display the data a little bit easier for users. I'll see how it goes, hopefully I can find a solution.
Thank you for your posts though, they're very informative and helpful and been really useful 🙂
