Forum Discussion
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 filter the page to only those users, but what i need to do is the reverse. Capture data on all users but not include the ones in the specific groups.
Example:
Master List - all have a passing rate of 92%
I need passing rate on just the specific group of users
Group 1 - passing rate on only this group ( i used page filter and basic filtering to select only those folks)
Master list minus those in group 1 - need passing rate for these but exclude people in group 1.
Any help or guidance, this is a bit complex for me as a beginner.
Thank you!
Hi Anonymous ,
You can use EXCEPT function to do this.
https://www.youtube.com/watch?v=TL81opk59aE
Regards,
Harsh NathaniAppreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
8 Replies
Hi Anonymous ,
You can use EXCEPT function to do this.
https://www.youtube.com/watch?v=TL81opk59aE
Regards,
Harsh NathaniAppreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!I think there are a couple of ways to accomplish this. I think I would do the next:
- create a distinct table of the user ID's
- Do not create a relationship between those tables. It should be disconnected.
- Place this new table as a slicer on your screen
- 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.
If you don't get it to work, you might want to post your PBIX file.
