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 would like to count the number of employee by department, and I use this formula
Following is the example of the table Terminate[ID]
Employee ID | Department | Status |
12345 | Finance | Voluntary |
12345 | Finance | Voluntary |
23456 | Account | Voluntary |
34567 | Human Resources | Voluntary |
45678 | Sales | InVoluntary |
Following is the example of the table Zero[Employee ID]
Employee ID | Department |
99999 | Marketing |
88888 | Marketing |
However, the result i got is
Which it should actually be 2 in finance and the total should be 4.
Please help me 🙏
Thank you
Solved! Go to Solution.
I see so you want to exclude Zero values.
With that in mind try this:
Test: (no except)
With:
Proud to be a Super User!
Hi,
This should do what you want:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Thank you for your answer.
However, in my full data set, there are the employee ID in 'Terminate' table that can match with the 'Zero' table so I still need to contain (except(values(
I see so you want to exclude Zero values.
With that in mind try this:
Test: (no except)
With:
Proud to be a Super User!
It works!
Thank you so muchhh.
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 |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |