Forum Discussion
Hide common blank value in matrix
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.
SQLBI explains well the parent child pattern and how to handle blank rows. Have a look here : Parent-child hierarchies – DAX Patterns
2 Replies
- Alex87
Solution Sage
SQLBI explains well the parent child pattern and how to handle blank rows. Have a look here : Parent-child hierarchies – DAX Patterns