How to create a hierarchy of calculated measures?

[Anonymous]

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

[v-kelly-msft · Accepted 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.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

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