Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
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