Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |