Average of sums

[Arthur_NS]

Hello,

With the example below, I'm trying to show in a graph the sum of country averaged per sector

What I'm trying to get at is for example for Sector A:

France = 1000+6000=7000

Germany=2000

Average=4500

A straight average would give me 3000 (average of 1000, 6000 and 2000).

Any idea to calculate this and show it on a graph for each sector?

Thank you,

Arthur

[Greg_Deckler]

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

[amitchandak · Accepted solution]

@Arthur_NS , see if a measure like this can help

averageX(values(Table[country]), calculate(sum(Table[sales])))

[Arthur_NS]

Sorry but that's not working, it gives me a simple sum of Sales.
Also the Sector variable is not taken into account

[Arthur_NS]

My bad it's actually working, thanks a lot!