Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |