Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Group average

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
 
Need Help
  • Omega's avatar
    Omega
    8 years ago

    Try creating a measure: 

     

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

2 Replies

  • Omega's avatar
    Omega
    Impactful Individual
    8 years ago

    Try creating a measure: 

     

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