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])
User | Count |
---|---|
42 | |
34 | |
26 | |
23 | |
15 |