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

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'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!