Compare 2 Tables

Hi BarryFletcher , hello bhanu_gautam, thank you for your prompt reply!

We could use the following measure to check the missing subbmitted staff:

MissingFlag = 
IF(
    NOT (
        MAX('Staff List'[Staff Name]) IN 
        CALCULATETABLE(
            VALUES('Timesheets'[Staff Name]),
            'Timesheets'[Work Week] = SELECTEDVALUE('Timesheets'[Work Week])
        )
    ),
    1,
    0
)

Then filter the staff table visual with MissingFlag=1:

Sample test for your reference:

Best regards,

Joyce

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

Hi BarryFletcher ，

Based on your data, switch to this measure:

MissingFlag = 
VAR SubmittedUserName=SUMMARIZE(
            FILTER(ALLSELECTED('Timesheet Hours'),'Timesheet Hours'[NewWorkWeek] = SELECTEDVALUE('Timesheet Hours'[NewWorkWeek])),'Timesheet Hours'[New Staff Name]
        )
VAR TAG=IF(
        NOT (
            CONTAINSSTRING ( CONCATENATEX ( SubmittedUserName, 'Timesheet Hours'[New Staff Name], "," ),
                TRIM(MAX('BLS_Report'[New Staff Name]))
            )
        ),
        1,
        0
    )
RETURN TAG

 For more detailed information, please check the attachment below.