Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filtering OUT names from a separate table

I have a master list that has all users listed by their ID.  Then i have specific groups that we ran tests against and collected information on for those groups.  I know i can use the filter, and fil...
danielkrol's avatar
danielkrol
Helper II
6 years ago

I think there are a couple of ways to accomplish this. I think I would do the next:

 

  1. create a distinct table of the user ID's
  2. Do not create a relationship between those tables. It should be disconnected.
  3. Place this new table as a slicer on your screen
  4. Create a measure like ("User" is your new distinct table)

 

select = IF(SELECTEDVALUE(Master[UID]) IN FILTERS('User'[ID]), 0,1)​

 

  • Add this measure to the filterpane of visual you want to filter
  • Tell in filter pane only to show if "select" = 1

It's a few steps, but I've used this technique multiple times and people seem to love this interaction.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I will try this out, thanks!

    • danielkrol's avatar
      danielkrol
      Helper II
      6 years ago

      If you don't get it to work, you might want to post your PBIX file.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yep, not working.  I can get the measure created, i disconnected the group list from the master table.  I think the complexity of another table where the activity is held may be causing issues.  When i add the measure to the filter on the card i have for "passed" % calculation.  I had to add a slicer for date - month/year to pull out data on specific time frame.

        Reality - i have the following tables:

        Activity table and when the activity occurred

        Master table - provides link to user detailed information (most measures are created under this table

        Then each table that now has a different group list to find understand that groups data.

         

        I would need to scrub my pbix file, as it contains sensitive info.  All tables are have the same userID as the main key for linking.

         

        I also was able to create a slicer with the group data that is no longer linked, but it doesn't impact the % passed data, and when adding the select measure to the visual filter, it doesn't allow me to update to state 1.