Group average

[Anonymous]

Hello,

Can you please support on how to create a DAX formula on how to calculate the average sales for each group?

Please see an example below:

 

Many thanks,

MariosChr90

[Omega · Accepted solution]

Try creating a measure: 

Average Sales = CALCULATE(AVERAGE(Table1[Amount]),ALLEXCEPT(Table1,Table1[Group]))

[Zubair_Muhammad]

@Anonymous

@Omega's MEASURE would work as a calculated column too