Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Drill down in matrix visualisation

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

 

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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