Forum Discussion

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...

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

Helper V

10 years ago

Thanks for the solutions!