I need to calculate the Average of a sum by group

[Posie13]

Here is my data. I have sales by team and period I want to sum that for every period and then get an average of the sum for all periods by team so my result should look like the final chart.

period	sale	team		Period sum	Average period sum  by team
Period 1	350	blue
period 1	150	blue	Period 1	500
period 2	250	blue			550
period 2	350	blue	Period 2	600
Period 1	50	red
period 1	40	red	Period 1	90
period 2	175	red			177.5
period 2	90	red	Period 2	265
				WF13:V18
Final chart
average sum of sales by period
Team	Average sum of sales
Red	177.5
Blue	550

[Ashish_Mathur]

Hi,

These measures work

S = SUM(Data[sale])

Measure = AVERAGEX(VALUES(Data[period]),[S])

Hhope this helps.

[MarkLaf · Accepted solution]

I think something like the below should work for you.

Measure = 
AVERAGEX( 
    SUMMARIZE( 'Table', 'Table'[team ], 'Table'[period ] ), 
    CALCULATE( SUM( 'Table'[sale] ) ) 
)

[Posie13]

Thanks so much I will give it a try