Forum Discussion

AlexanderRbt's avatar
AlexanderRbt
Helper I
6 years ago
Solved

Creating average grouped by multiple grouping variables

Hi all,   I would like to create a measure that represents the average of two (or potentially more) categories.   My data looks like this   User  Cat_A       Value 1       East         30 1...
Need Help
  • SteveCampbell's avatar
    SteveCampbell
    6 years ago

    Try:

    Average of response average per CAT= 
      CALCULATE(AVERAGE('answers_valid'[value]),
        ALLEXCEPT('my_data','my_data'[Cat_A],'my_data'[Cat_B]))

     

    Appreciate your Kudos
    Connect with me!

    Stay up to date on  
    Read my blogs on  

dax's avatar
dax
Community Support
6 years ago

Hi AlexanderRbt,

You could try to use below measure or use built-in function like below

Measure 2 = CALCULATE(AVERAGE(t3[value]), ALLEXCEPT(t3,t3[user],t3[cate]))

or

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlexanderRbt's avatar
AlexanderRbt
Helper I
6 years ago

Thank you SteveCampbell and dax for your solutions. You both came to the same conclusion but I can only accept one as the right one.

 

This works very well can could be extended to groupings of more than three categories.

 

Thanks!

A.