Matrix - Avoid Duplicate items in hierarchies

[CarlsBerg999]

Hi,

I have a Matrix that shows a situation like in the picture. The underlying issue is that for some lines there is a hierarchy and i need this feature. For some lines however, there is no real hierarchy so i've just written the same text over and over again. 

The result is still better than "blanks" with 172k € as value, but does anyone have an idea on how to filter the items out if the text is same for all levels of the hierarchy? E.g. The ideal situation would be that this would not be expandable at all but other lines would be. 

[DataInsights · Accepted solution]

@CarlsBerg999,

See the article below:

https://www.daxpatterns.com/parent-child-hierarchies/ 

[CarlsBerg999]

Dear lord.. Implementing this on a complex model will take quite some time. However, i guess that's the solution i was expecting. I really hoped someone would just point out a "suppress duplicates" -button. Oh well.