How to hide/remove Blank Rows in Matrix and show the values

Hi Anonymous ,

I modified the data structure and made a demo for you.

Measure = 
var _userName = SWITCH(TRUE(),
ISINSCOPE('Table3'[Level 9 Leader]),MAX('Table3'[Level 9 Leader]),
ISINSCOPE('Table3'[Level 8 Leader]),MAX('Table3'[Level 8 Leader]),
ISINSCOPE('Table3'[Level 7 Leader]),MAX('Table3'[Level 7 Leader]),
ISINSCOPE('Table3'[Level 6 Leader]),MAX('Table3'[Level 6 Leader]),
ISINSCOPE('Table3'[Level 5 Leader]),MAX('Table3'[Level 5 Leader]),
ISINSCOPE('Table3'[Level 4 Leader]),MAX('Table3'[Level 4 Leader]),
ISINSCOPE('Table3'[Level 3 Leader]),MAX('Table3'[Level 3 Leader]),
ISINSCOPE('Table3'[Level 2 Leader]),MAX('Table3'[Level 2 Leader]))
var _totalAssigned = IF(NOT(ISBLANK( _userName)),MAXX( FILTER(ALL(Table1),[Employee Name]=_userName),[Total Assigned])  ,BLANK())
RETURN _totalAssigned

Best Regards,

Wearsky

Hi Anonymous 
I have make some changes shown below as this is the standard form of parent child herirachy.

The Requested output 

For better reference please refer below pbix link -->
How to hide/remove Blank Rows in Matrix and show the values Solved 

If it helps please Accept it as solution