Hide common blank value in matrix

[Anonymous]

I have this matrix that shows values in common for several hierarchy level.The problem is that some of my orgs don't have the same depth as others. In this case, in my table these are null. I'd like to find a way of hiding a row if there are no other criteria and the number on the right remains the same.

Basically, I want to hide, the rows in green.

[Alex87 · Accepted solution]

SQLBI explains well the parent child pattern and how to handle blank rows. Have a look here : Parent-child hierarchies – DAX Patterns

[Anonymous]

In the example you gave me, there is a step  :

Sum Amount :=

SUM ( StrategyPlan[Amount] )

But in my case, I have my data are in a seperate table. Plus, it's not really a value that I have, it's an ID, so I don't know if I need to sum it.