Forum Discussion
Solved
How to add multiple Slicer
Hi Team, Im doing a report to verify the users. lets say i have 50 users i have made a table that can select users; once it is selected automatically, it will come to another table using Slicer. ...
Hi mohamedm
in your case please use
Filter 1 =IF(ISFILTERED('Name'[Employee Name]),IF(MAX('**bleep** Access Control'[Employee Name]) IN VALUES('Name'[Employee Name]),0,1),1)
Hi mohamedm
in your case please use
Filter 1 =
IF(
ISFILTERED('Name'[Employee Name]),
IF(
MAX('**bleep** Access Control'[Employee Name]) IN VALUES('Name'[Employee Name]),
0,
1
),
1
)
it looks like the issue is with the MAX function, i change to CONTAINS its working fine thanks for your support