Filtering a related inline view

I have a candidates table. My candidates have a ‘currently recruiting for job’ field that is a reference to my jobs table. I also have a table that is a list of jobs that match to each candidate.
So John is matched to job 1,2 and 3. He is currently being recruited for job 1. I want the inline view for my references from the match table to exclude his currently being recruited for job. Can I do this?

If I have understood you correctly, you can try with this expression in Valid_if of your jobs ref column

SELECT(Jobs[KeyColumn], TRUE) - LIST([_THISROW].[JobsRefColumnName])
1 Like