Count if value is not

[CarlsBerg999]

Hi,

Im trying to count personnel that is not in a specific RLU ID. I have multiple ID's that need to excluded. How do i do this? The formula works fine, if i just use one ID.

Personnel = CALCULATE(COUNTROWS('Employee Masterdata'),'Employee Masterdata'[RLU ID] <> "ID1234" || "ID4321")

Thanks for the help!

[manikumar34 · Accepted solution]

Hi @CarlsBerg999 , 

try the below

Personnel = CALCULATE(COUNTROWS('Employee Masterdata'),NOT('Employee Masterdata'[RLU ID]) IN {"ID1234","ID4321"})