Forum Discussion

bullius's avatar
bullius
Helper 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

Turnipface's avatar
Turnipface
Advocate 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?

jahida's avatar
jahida
Impactful Individual
8 years ago

I'm not really sure what you mean... the original question wanted an average, what's an average of text values? Also if the columns are in different tables, how are they associated?