DAX : count ID that have no linked value from other table

[Rinn]

Hi,

I have 2 tables :

Employees

Person	Location
x1	A
x2	A
x3	B
x4	B

* <-> 1

Adress

Location	Country
A	xxxxxxxx
B	xxxxxxxx
C	xxxxxxxx

How do I count the number of locations that have no employees ?

Thanks for your help !

[Musadev · Accepted solution]

hi @Rinn 
do you want get the count of location or location IDs where there isn't any employees?
Create 2 measures to get the count of employees in each location. and where filter out location where the count is >0.
First measure.

Count = COUNT(employees[Location])

second measure.

count2 = 
CALCULATE(
    [Count]+0)

Now use the visual filter to get only those records where count2 is 0.