How to change the Roll up totals for Average or something else?

[Tony88]

Hello, 

Can anybody please tell me how to change the Roll Up number to Average on Manger Level? 

I have a table with different measures such as (Elevation %, CSAT, etc). Each measure calculates differently and has a different formula. When it rolls up to manager level number does not make any sense.  I need to change them to average. Is there a way I can do this? 

https://drive.google.com/file/d/1h_hVz0MIEdDtHZED21arK6KCPOryp20z/view

Thank you 

[Tony88]

@Ashish_Mathur  Thank you so much. this works. I appreciate it. 

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Does this for the Elevation % measure

Revised Elevation % = AVERAGEX(VALUES(Closes_Assists_KB_NPS_ByMonthByManager[Name]),[Elevation %])

Do the same for the rest as well.

Hope this helps.