Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |