I need help creating a Table Visual showing IDs Missing From Another Table

Hi, Jadegirlify 

Based on your information, I create sample tables:

Create a Calendar table, create a column named Year and manage relationship:

Calendar = CALENDAR(MIN(Breathing_Test[Breathing Test Date]), MAX(Breathing_Test[Breathing Test Date]))

Year = YEAR(Calendar[Date])

Then create a new measure:

OperatorsNotPerformingTests1 = 
CALCULATE(
    MAX(Master_Operators[Operator ID]),
    FILTER(
        Master_Operators,
        NOT(
            Master_Operators[Operator ID] IN 
            SELECTCOLUMNS(
                FILTER(Breathing_Test, YEAR(Breathing_Test[Breathing Test Date]) = SELECTEDVALUE(Calendar[Year])),
                "Operator ID", Breathing_Test[Operator ID]
            )
        )
    )
)

Use Master_Operators[Operator Name] and Master_Operators[Operator ID] as columns. Add a measure to the filter of the table visualization. Add a slicer for Calendar[Year] to filter the data by year. Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.