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

Anonymous's avatar
Anonymous
Not applicable
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

bullius's avatar
bullius
Helper V
10 years ago

Thanks for the solutions!