Drill down in matrix visualisation

[Anonymous]

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 when i try to drill down my matrix from area level view to cluster level view :

the row wise averages are correct but the column wise averages are wrong

also when i use the "DRILL DOWN" functionality by selecting/Right -clicking the area row inorder to view the cluster level view :

the averages at column level are wrong

how can we tackle this problem?

Thanks in Advance

This is the measure i have been using for average :

AVERAGEX(ADDCOLUMNS(SUMMARIZE('SP: Heatmap - Sub','SP: Heatmap - Sub'[Area],'SP: Heatmap - Sub'[Control]),"Value",CALCULATE(AVERAGE('SP: Heatmap - Sub'[Values]))),[Value])

[Anonymous]

HI @Anonymous,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng