Sum a measure

[Bergh]

Hi. Why can't I sum a measure. I have two diffrent measure  that I want to get the total sum on.

Thanks!

//Berg

[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!

[Greg_Deckler · Accepted solution]

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