Forum Discussion
Helper IISum a measure
Hi. Why can't I sum a measure. I have two diffrent measure that I want to get the total sum on.
Thanks!
//Berg
Bergh 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.
2 Replies
- Greg_Deckler
Community Champion
Bergh 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. - ValtteriN
Hi,
To remove filters from your calculation and get the SUM of all you can create measure like this: CALCULATE(SUM('Table'[Column]),ALL('Table')). I am not sure what you mean you can't get the SUM here. If you want to summarize data in your table visual and you are wondering why it doesn't function I recommend checking the data format. If your data format is okay (e.g. decimal number) you should automatically get the SUM as an aggregation option:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
