Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rinn
Frequent Visitor

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

Hi,

 

I have 2 tables :

Employees

PersonLocation
x1A
x2A
x3B
x4B

* <-> 1

Adress

LocationCountry
Axxxxxxxx
Bxxxxxxxx
Cxxxxxxxx

 

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

 

Thanks for your help !

1 ACCEPTED SOLUTION
Musadev
Resolver III
Resolver III

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.

Musadev_0-1711728845800.png

 

View solution in original post

1 REPLY 1
Musadev
Resolver III
Resolver III

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.

Musadev_0-1711728845800.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.