category and subcategory in matrix

[Piotr123]

In my table, not every index has a subcategory. How can I hide the empty rows in a matrix visual?

[MasonMA]

Hello @Piotr123 

The most straightforward way would be applying a filter on Subcategory level. 

[Piotr123]

Hello MasonMA,

Thank you for your response.

When I apply the filter this way, the Index data disappears. My goal is to keep all the data intact and remove only the empty subcategory headers.

Do you have any ideas how to achieve this?

[MasonMA]

Hello @Piotr123 

Then i would suggest using Minimal for Style, Tabular for Layout and disabling +/- icon under Row headers. 

[Piotr123]

Thank you

It seems this issue might be related to a ragged hierarchy, which could potentially be addressed using a DAX measure based on a parent-child hierarchy. However, I'm not entirely sure how to implement such DAX measure 

[MasonMA]

@Piotr123 

Please show the expected layout in Excel so that other users can come up with a solution.