Forum Discussion

mschultens's avatar
mschultens
New Member
8 years ago
Solved

Calculate Average per category

Hello everyone,   I spent a lot of time already looking at similar problems to the one I have, but nothing really worked for me.  Assume I have a table with a category and some values. How can I c...
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi mschultens,

     

    Did you use the original expression in the calculated column? It works for me. Please refer:

     

     

    Or you can try measure:

    AverageMeasure =
CALCULATE (
    AVERAGE ( Table3[Value] ),
    FILTER ( ALLSELECTED ( Table3 ), Table3[Category] = MAX ( Table3[Category] ) )
)

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi mschultens,

 

Did you use the original expression in the calculated column? It works for me. Please refer:

 

 

Or you can try measure:

AverageMeasure =
CALCULATE (
    AVERAGE ( Table3[Value] ),
    FILTER ( ALLSELECTED ( Table3 ), Table3[Category] = MAX ( Table3[Category] ) )
)

Thanks,
Xi Jin.

mschultens's avatar
mschultens
New Member
8 years ago

I had a mistake somewhere else in my model. Both solutions work fine! Thank you very much guys! :-)