Forum Discussion

bullius's avatar
bullius
Icon for Helper V rankHelper V
10 years ago
Solved

Average based on distinct values in another column

Hello,   I have data that looks like this:     Employee Employment Age  1 a 35 1 b 35 2 a 40 3 a 35 4 a 51 4 b 51   I want to calculate the average age of...
Need Help
  • jahida's avatar
    jahida
    10 years ago

    This should work (tested locally):

     

    Measure = AVERAGEX(SUMMARIZE(Table1, Table1[Employee], Table1[Age]), Table1[Age])

  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi bullius,

    You can also create the measure using the formula.

    Measure  = AVERAGEX(VALUES(Table[Employee]), CALCULATE(AVERAGE(Table[Age])))



    Thanks,
    Lydia Zhang

jahida's avatar
jahida
Icon for Impactful Individual rankImpactful Individual
10 years ago

This should work (tested locally):

 

Measure = AVERAGEX(SUMMARIZE(Table1, Table1[Employee], Table1[Age]), Table1[Age])

Turnipface's avatar
Turnipface
Icon for Advocate I rankAdvocate I
8 years ago

Hey Jahida,

This looks like it can solve an issue that i'm experiencing.
However, how could it work if the column "Employee" is in another table? 
And would it be any different if it's not neccessarily a number, but text?