Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |