ISINSCOPE Hide Empty Rows in a Matrix Hierarchies

Hi Maggie;

Thanks for the video was so helpful,  this is a complete example thaT I need to do:

Data Base

The Idea is make a visual Matrix and must work in this way:
Don´t show empty rows.
Respect the value and content in before levels
Respect the Total Value always

This is the way to show the Matrix in each change of hierarchies:

Im tryng whit this code but don´t work all well:

Medida = 
IF (
    SWITCH (
        TRUE (),
        AND ( ISINSCOPE ( Hoja6[Level 1] ), ISBLANK ( VALUES ( Hoja6[Level 1] ) ) ), BLANK (),
        SUM ( Hoja6[Value] )
    ),
    IF (
        SWITCH (
            TRUE (),
            AND ( ISINSCOPE ( Hoja6[Level 2] ), ISBLANK ( VALUES ( Hoja6[Level 2] ) ) ), BLANK (),
            SUM ( Hoja6[Value] )
        ),
        IF (
            SWITCH (
                TRUE (),
                AND ( ISINSCOPE ( Hoja6[Level 3] ), ISBLANK ( VALUES ( Hoja6[Level 3] ) ) ), BLANK (),
                SUM ( Hoja6[Value] )
            ),
            IF (
                SWITCH (
                    TRUE (),
                    AND ( ISINSCOPE ( Hoja6[Level 4] ), ISBLANK ( VALUES ( Hoja6[Level 4] ) ) ), BLANK (),
                    SUM ( Hoja6[Value] )
                ),
                IF (
                    SWITCH (
                        TRUE (),
                        AND ( ISINSCOPE ( Hoja6[Level 5] ), ISBLANK ( VALUES ( Hoja6[Level 5] ) ) ), BLANK (),
                        SUM ( Hoja6[Value] )
                    ),
                    IF (
                        SWITCH (
                            TRUE (),
                            AND ( ISINSCOPE ( Hoja6[Level 6] ), ISBLANK ( VALUES ( Hoja6[Level 6] ) ) ), BLANK (),
                            SUM ( Hoja6[Value] )
                        ),
                        IF (
                            SWITCH (
                                TRUE (),
                                AND ( ISINSCOPE ( Hoja6[Level 7] ), ISBLANK ( VALUES ( Hoja6[Level 7] ) ) ), BLANK (),
                                SUM ( Hoja6[Value] )
                            ),
                            SWITCH (
                                TRUE (),
                                AND ( ISINSCOPE ( Hoja6[Level 7] ), ISBLANK ( VALUES ( Hoja6[Level 7] ) ) ), BLANK (),
                                SUM ( Hoja6[Value] )
                            )
                        )
                    )
                )
            )
        )
    )
)

In advance thanks for your time!