Compare Two Table Using Select Statement

[jafferjee]

Scenario:

I have Table A [USERS] with a list of all possible User ID, and Table B [Attendance] with User Id that are already In Table B. I want to find the User ID in Table A that are not yet used in Table B.

ISNOTBLANK(SELECT(
Users[User ID],
Not(IN([User ID], Attendance[User ID]))
)
)

Above Select statement fetch all A Table Records not Skip Table B Records.

I don't know where i am doing wrong please help