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