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.

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.

      • jochendecraene's avatar
        jochendecraene
        Helper V
        4 years ago

        Hi

         

        I'd like to use this solution, but I also have a subcategory and year that I have to take into account.

        I tried using extra filters for subcategory and year, but keep getting errors.

        Can someone help me?

        This is what my table looks like