Forum Discussion
bullius
Helper V
Helper VAverage 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...
This should work (tested locally):
Measure = AVERAGEX(SUMMARIZE(Table1, Table1[Employee], Table1[Age]), Table1[Age])
Hi bullius,
You can also create the measure using the formula.Measure = AVERAGEX(VALUES(Table[Employee]), CALCULATE(AVERAGE(Table[Age])))
Thanks,
Lydia Zhang
jahida
Impactful Individual
Impactful IndividualThis should work (tested locally):
Measure = AVERAGEX(SUMMARIZE(Table1, Table1[Employee], Table1[Age]), Table1[Age])
Awesome. Thanks a lot, it helped me.