How to add multiple Slicer

[mohamedm]

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

[mohamedm]

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 latest 

i just need everything to be listed

[MattiaFratello · Accepted solution]

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

)

[mohamedm]

it looks like the issue is with the MAX function, i change to  CONTAINS its working fine thanks for your support

[MattiaFratello]

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!

[mohamedm]

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 

[MattiaFratello]

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!

[mohamedm]

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 . 

[MattiaFratello]

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!