Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Matrix Drill Down error

Hi team , I have a matrix with rows,columns and values as the following :      In Values field :  i have averages (measure)   This is the following matrix :   The problem starts wh...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi speedramps ,

Thanks for the Reply,

To be more specific , 

my goal is to find averages at area and cluster level.

as you are aware when we include 2 values under rows in a matrix it enables us to have drill through.

Area and cluser are my drill through option

when i drill from area level to cluster level , the vertical averages are showing wrong or same as area level averages

 

Thanks

 

speedramps's avatar
speedramps
Super User
2 years ago

Please click on the link to downlaod the solution.

It does exactly what you asked.

I asked you for more example data but you did not go to the effort to provide any.

Whereas I have taken a lot of uppaid time and effort to answer your question with an example and link.
Please be polite and accept this free solution and click thumbs up, if you wish to to receive more free support.
If you want somethings else but didnt ask the right question, then close this question and create a new one.

 

Click here to download solution 

 

Answer = 
SWITCH(TRUE(),
HASONEVALUE(Stats[Cluster]) && HASONEVALUE(Stats[Column]),SUM(Stats[Amount]),
AVERAGEX(Stats,Stats[Amount])
)