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

HI mschultens

 

Try this MEASURE.

Earlier typically works in a Column not a MEASURE

 

AverageMeasure =
CALCULATE ( AVERAGE ( table[value] ), ALLEXCEPT ( Table, table[category] ) )
  • 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.

  • zamboni1199's avatar
    zamboni1199
    Helper II
    7 years ago

    Thank you!  That just helped me with a similar issue too.