Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiple selection on Disconnected Slicer

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

Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    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.

4 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks alot, appreciate it!

       

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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