Drill down in matrix visualisation

Anonymous — Mon, 30 Oct 2023 17:08:45 GMT

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])

Re: Drill down in matrix visualisation

Anonymous — Wed, 01 Nov 2023 07:31:38 GMT

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

topic Drill down in matrix visualisation in Developer

Drill down in matrix visualisation

Re: Drill down in matrix visualisation