Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 !
Solved! Go to 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.
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.
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |