Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
SQLBI explains well the parent child pattern and how to handle blank rows. Have a look here : Parent-child hierarchies – DAX Patterns
SQLBI explains well the parent child pattern and how to handle blank rows. Have a look here : Parent-child hierarchies – DAX Patterns
In the example you gave me, there is a step :
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |