Forum Discussion

Rsanjuan's avatar
Rsanjuan
Icon for Advocate III rankAdvocate III
10 years ago
Solved

Calculating Average of Average help

Hi,   I have a scenario where I want to compute the total average of one person and another person based on what is selected on a slicer.   Here is an example:   1.  Selected one person where the...
Need Help
  • Rsanjuan's avatar
    Rsanjuan
    10 years ago

    BhaveshPatel and Greg_Deckler,

     

    I was able to figure out the DAX expression for this:

     

    AvgofAvgPM = AverageX(Values(Job[Project Manager]),Job[PM Rating])

     

    Basically taking a unique value in the table project manager, and then getting the average value of each project manager.  Then it takes those values and just averages it.  

     

    Thanks!

     

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

Rsanjuan

 

In your scenario, as the PM Rating is measure, we are not able to use AVERAGE function to return average values directly. We need to create a new column with the same DAX which is used by "PM Rating" measure. Then we can create a new measure with AVERAGE function.

 

 

 

Thanks & Regards,

Bhavesh

Rsanjuan's avatar
Rsanjuan
Icon for Advocate III rankAdvocate III
10 years ago

BhaveshPatel and Greg_Deckler,

 

I was able to figure out the DAX expression for this:

 

AvgofAvgPM = AverageX(Values(Job[Project Manager]),Job[PM Rating])

 

Basically taking a unique value in the table project manager, and then getting the average value of each project manager.  Then it takes those values and just averages it.  

 

Thanks!

 

 

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Rsanjuan

     

    If you can get your problem solved by the last DAX expression you posted, you can mark your last post as answer to close this thread.

     

    Best Regards,

    Herbert

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Nice, I didn't think of using VALUES, nice call.