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 ...
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.

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