Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
adithyanv
Employee
Employee

Drill down in matrix visualisation

Hi team ,

I have a matrix with rows,columns and values as the following :

adithyanv_2-1698684319108.png   In Values field :  i have averages (measure)

 

This is the following matrix :

adithyanv_1-1698684235582.png

The problem starts when i try to drill down my matrix from area level view to cluster level view :

 

adithyanv_0-1698685718519.png

 

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

adithyanv_4-1698685316495.png

 

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

 

 

1 REPLY 1
v-shex-msft
Community Support
Community Support

HI @adithyanv,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.