Forum Discussion

AlexanderRbt's avatar
AlexanderRbt
Icon for Helper I rankHelper I
7 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
    7 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  

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 years ago

Please check quick measure option. Right click on a table or field and click on Quick measure. And then try

 

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.

AlexanderRbt's avatar
AlexanderRbt
Icon for Helper I rankHelper I
7 years ago

Hello amitchandak 

 

Thanks for your idea. This is precisely what I tried with one grouping variable and it works perfectly. However, what if I have two grouping variables (User and Cat_A in my example).

 

Any ideas?

 

Thanks,

A.

  • SteveCampbell's avatar
    SteveCampbell
    Icon for Memorable Member rankMemorable Member
    7 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