Forum Discussion
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. but i want one more table ( pending to verify) which is to identify not-selected user from main table
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)
8 Replies
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
Hi mohamedm ,
Create a table with distinct employees (make sure to not have an active relationship with your current table).
Use the distinct employee column from your new table in the slicer.
Create two identical tables from your main table, in one of them set this filter =1 (you are going to create this filter throug DAX Measure).
Filter = IF( ISFILTERED('financials (2)'[Country]), IF( MAX(financials[Country]) IN VALUES('financials (2)'[Country]), 0, 1 ), 1 )Did I answer your question? Mark my post as a solution!
Thanks for the reply.. my employee daya is dynamic it will change evry min . who ever inside it will be there if anyone left it will remove from DB also i use direct query .
That's not a problem, you can still create a copy of your table using DAX
NewTable =
SUMMARIZE (
YourTable, -- The name of the table you want to duplicate
YourTable[Column1], -- The columns you want to keep distinct
YourTable[Column2], -- Add more columns as needed
-- Add other columns you want to keep in the duplicated table
)Did I answer your question? Mark my post as a solution!
ijust checked again selected is working but im not getting not selected list, i just need like below if any more country got selected , in selected list it should get add and remove from un selected table
Filter = 1 in one table
Filter = 0 in the other table
Using the formula provided above
No relationship btw the tables
Please check, it should work
Did I answer your question? Mark my post as a solution!
Great it seems working now, but only one issue its not getting select all, Once i selected only its getting remove from first table and adding into next table
Once i select 2 its just updating only latesti just need everything to be listed
