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 All,
I have a matrix visual like below.
Where I have 2 calculated measures, Functional Fields and Planning Fields in the values section of the visual.
They are not direct calculations, have dependency with other measures calculation.
Functinal Fields is the aggregation value of another 6 measures.
Just wanted to check is there any way, we can split "Functional Field" measure to get the detailed layers to deep dive to know in which area my percentage are low?
Or Is it possible in the same matrix visual or do I need to create a drill through page?
Thanks In Advance
Solved! Go to Solution.
Hi @Anonymous ,
You may try below measure but may be a little complex in your case:
Measure = IF(ISINSCOPE('Table'[Country]),'Table'[subcategory],IF(ISINSCOPE('Table'[Area ]),'Table'[Category]))
And you will see:
'Table'[Subcategory]and 'Table'[Category] are another 2 measures.
For the related .pbix file,you may refer to attachment.
Hi @Anonymous ,
You may try below measure but may be a little complex in your case:
Measure = IF(ISINSCOPE('Table'[Country]),'Table'[subcategory],IF(ISINSCOPE('Table'[Area ]),'Table'[Category]))
And you will see:
'Table'[Subcategory]and 'Table'[Category] are another 2 measures.
For the related .pbix file,you may refer to attachment.
Hi @Anonymous
Unfortunately Hierarchy of calcualted columns in a matrix view is not possible.
Drill through page is the best option.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |