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.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

mschultens

 

You can simply use Average(table[value]) as well if you choose not to put VALUE in the Table VISUAL

 

Your formula would work as a calculated column

mschultens's avatar
mschultens
New Member
8 years ago

Thank you, but that does not work for me, because I want to put the different averages into one visualization.

    • mschultens's avatar
      mschultens
      New Member
      8 years ago

      It gives me an error saying that a single value for category cannot be determined. I tried putting a MAX() in front, but that gives the same error.

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