Forum Discussion

mohamedm's avatar
mohamedm
Frequent Visitor
1 year ago
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. ...
Need Help
  • MattiaFratello's avatar
    MattiaFratello
    1 year ago

    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's avatar
mohamedm
Frequent Visitor
1 year ago

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's avatar
MattiaFratello
Super User
1 year ago

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!