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! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Lydia,

     

    I am facing similar issue and your measure helped me a lot however In my case i need the average based on selection of three different slicers, i can see you have used one slicer with values (employees)in above measure. how about if I have three such values (three columns) that needs to be make averages of averages.