Filter Out Same-Value Data in One Column, When a Value in Another Column Is Not Present

Hi ClackamasAshley ,

I create a Power BI file and uploaded it here for you to have a look.

The way I have done it is:

I am assuming it will not always be Casey you want to select so it is dynamic.

I created a new table called 'Deputies'. This doesn't have an Active relationship, because we don't want it to filter the Callouts.

I've added a slicer from the 'Deputies' table to allow us to select just one Deputy.

We then create a measure that does the following:

1. see who is the selected deputy

2. get the current case number (as this measure will be displayed on a table, each row will have its own case number)

3. create table with all the distinct case numbers that the selected deputy has worked on

4. check if the current case number is in the table of all cases that the deputy has worked on.

Hope this helps out - and if anybody has a quicker or better way of doing it let me know. 

If I helped, please mark my post as the answer and a kudos will be very much appreciated 🙂

Merry Christmas and a Happy New Year !

Boyan