A measure that can display a table of people who haven't done the courses

[rlhim]

i'm trying to have a table that tells me which people haven't done the courses.

I have 2 tables: one with all of the people and the other with the people who has done the courses.

But i want the table to be able to filter depending of the course

1 table: Personnel

IP	Name
001	Maria
002	Manuel
003	Rachel
004	Stephanie
005	George
006	Victor
007	Benjamin

2 table: Database

IP	Name	Date	Course	Status
001	Maria	6-Dec-22	Course 1	Asigned
001	Maria	13-Dec-22	Course 2	Asigned
002	Manuel	15-Dec-22	Course 1	Asigned
002	Manuel	22-Dec-22	Course 2	Asigned
003	Rachel	27-Dec-22	Course 1	Asigned
004	Stephanie	29-Dec-22	Course 2	Asigned

I want the result to be so I can filter by course

Course 1. People that need to be assigned

IP	Name
004	Stephanie
005	George
006	Victor
007	Benjamin

Course 2. People that need to be assigned

IP	Name
003	Rachel
005	George
006	Victor
007	Benjamin

[LuizKoller · Accepted solution]

I usually use a morning for this kind of problem:

it is important that the filter direction is Single (if not possible, you can try something using CROSSFILTER).

[lbendlin]

You should be able to do this via "show items with no data".  Otherwise, use a disconnected table for the Personnel and then create the necessary measures.