Multiple selection on Disconnected Slicer

[Afiq_Danial]

HI, I have a table consisting of staffs' name and their certificate. I've also created a disconnected table. My current slicer will only work properly with on one selection. I want my slicer to have multiple selection.

This is my measure right now:

check =

var _sel = 'Disconnected Slicer'[SelectedCertificate]

var _chain = MAX('Staff Booking'[Certification])

RETURN

Switch(True(),

//containsstring(_chain,_sel),1,

SEARCH( _sel, _chain, 1,0 ) > 0, 1,

IF(_sel = "No Certificate" && ISBLANK(_chain), 1, 0) > 0, 1,

IF(ISBLANK(_sel), 1, 0) > 0, 1,

0)

This is the file that i have right now if u want to help me.

https://drive.google.com/drive/folders/1pQu_16bfUPBgOXaGIOLenl5ya3SBi3tP?usp=share_link

Thank you! Appreciate all the help

[v-jianboli-msft · Accepted solution]

Hi @Afiq_Danial ,

Please try:

Flag = 
VAR _a =
    SELECTCOLUMNS ( 'Disconnected Slicer', "Slicer", [Certificate] )
VAR _b =
    ADDCOLUMNS (
        _a,
        "Count",
            SWITCH (
                TRUE (),
                ISBLANK ( MAX ( 'Staff Booking'[Certification] ) )
                    && [Slicer] = "No Certificate", 1,
                MAX ( 'Staff Booking'[Certification] ) <> BLANK ()
                    && CONTAINSSTRING ( MAX ( 'Staff Booking'[Certification] ), [Slicer] ), 1
            )
    )
RETURN
    IF (
        SUMX ( _b, [Count] )>=1
            || NOT ( ISFILTERED ( 'Disconnected Slicer'[Certificate] ) ),
        1,
        0
    )

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Afiq_Danial]

Thanks alot, appreciate it!

[v-jianboli-msft]

Hi @Afiq_Danial ,

Please try:

Flag =
VAR _a =
    SELECTCOLUMNS ( 'Disconnected Slicer', "Slicer", [Certificate] )
VAR _b =
    ADDCOLUMNS (
        _a,
        "Count",
            SWITCH (
                TRUE (),
                ISBLANK ( MAX ( 'Staff Booking'[Certification] ) )
                    && [Slicer] = "No Certificate", 1,
                MAX ( 'Staff Booking'[Certification] ) <> BLANK ()
                    && CONTAINSSTRING ( MAX ( 'Staff Booking'[Certification] ), [Slicer] ), 1
            )
    )
VAR _c =
    COUNT ( 'Disconnected Slicer'[Certificate] )
RETURN
    IF (
        _c = SUMX ( _b, [Count] )
            || NOT ( ISFILTERED ( 'Disconnected Slicer'[Certificate] ) ),
        1,
        0
    )

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Afiq_Danial]

Hi, thanks for your help. but what i mean is that when i choose No Certificate and CISSP (Associate), the number 1 should only show on bryan, benjamin, james, and riley rows