Segmentation can filter another segmentation

Is possible for one segmentation filter to have options excluded or filtered from another segmentation filter? Example: 1º segmentation filter [x]A - [ ]B - [ ]C 2º segmentation filter [disabl...

Need Help

v-jianboli-msft

3 years ago

Hi Arthurfrc ,

Please try:

First create tree tables for slicers:

Then apply measure [Flag for segmentation2] to segmentation2, [Flag for segmentation3] to segmentation3:

Flag for segmentation2 =
VAR _a =
    SELECTCOLUMNS ( 'Table', "1", [segmentation] )
RETURN
    IF (
        ISFILTERED ( 'Table'[segmentation] )
            && MAX ( 'Table 2'[segmentation] ) IN _a,
        0,
        1
    )


Flag for segmentation3 =
VAR _a =
    SELECTCOLUMNS ( 'Table', "1", [segmentation] )
VAR _b =
    SELECTCOLUMNS ( 'Table 2', "2", [segmentation] )
RETURN
    SWITCH (
        TRUE (),
        ISFILTERED ( 'Table'[segmentation] ) && ISFILTERED ( 'Table 2'[segmentation] )
            && MAX ( 'Table 3'[segmentation] ) IN UNION ( _a, _b ), 0,
        ISFILTERED ( 'Table'[segmentation] )
            && NOT ( ISFILTERED ( 'Table 2'[segmentation] ) )
                && MAX ( 'Table 3'[segmentation] ) IN _a, 0,
        NOT ( ISFILTERED ( 'Table'[segmentation] ) )
            && ISFILTERED ( 'Table 2'[segmentation] )
            && MAX ( 'Table 3'[segmentation] ) IN _b, 0,
        1
    )