Dynamic column in matrix visual

Hi Anonymous 

Sure, please see the explanation commented in the expression.

Measure = 
VAR __sum = SUM( 'Table'[Values] ) -- sum of values 
VAR __selction = VALUES( 'Columns'[Column1] ) -- list of values selected on the slicer 
RETURN 
SWITCH(
    TRUE(),
    /* 
        ISINSCOPE - 
            Returns TRUE if the column is in included in the filter context -
            t will return TRUE for the column if it is used in the Matrix and all columns with lower granularity 
            ISINSCOPE( 'Table'[Level3] ) will return true for level3 and level4 
        NOT 
            Reverses TRUE to FALSE, so when ISINSCOPE( 'Table'[Level3] ), TRUE will be set on 'Table'[Level1] and 'Table'[Level2]
        "Level2" IN __selction 
            Is the second part of SWITCH logical test that has to be met 
            "Level2" is a text that is searched for in currently election of Columns'[Column1] / slicer

        && 
            is other way of saing AND in DAX 
            Both cryteria, NOT ISINSCOPE( 'Table'[Level3] ) and  "Level2" IN __selction -- have to be met for __sum value to be returned
    */
    NOT ISINSCOPE( 'Table'[Level2] ) && "Level1" IN __selction, __sum, 
    NOT ISINSCOPE( 'Table'[Level3] ) && "Level2" IN __selction, __sum,
    NOT ISINSCOPE( 'Table'[Level4] ) && "Level3" IN __selction, __sum,
    "Level4" IN __selction, __sum
)

 let me know if it's clear enough for you.