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]))

Omega's avatar
Omega
Impactful Individual
8 years ago

Try creating a measure: 

 

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

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    Omega's MEASURE would work as a calculated column too