Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All. I am completely new to Power BI, DAX and all that but I have been trying lately to ease my work as much as possible and it worked until now.
I have a list of employees (some appearing more than once) and priorities/goals (text) for each employee (some with more than 1). I am in search of a DAX function or something to allow me to see how many employees have how many priorities entered, blank included.
Could someone please help me out with this?
Many thanks
Solved! Go to Solution.
Can you mark a post as a solution. This will be very nice if the post was helpfull for you 🙂
Proud to be a Super User!
Thank you, measure can be:
Matrix:
COUNT = COUNTA('Table'[Priority Name])
or
COUNTBLANK = COUNTBLANK('Table'[Priority Name])
Other question is that you want like this:
Count of priority | Count of employee |
Empty | 2 |
1 | 1 |
2 | 2 |
3 | 1 |
4 | 0 |
5 | 1 |
Proud to be a Super User!
@andhiii079845 thank you so much. This is so helpful. Could you please help me with some guidance on how to have a table to look like the section "Should look like" ? Many thanks
I only know the solution to create a helping table with the texts and a crossjoin with the countries. You generate a list of all combinations and than you can do a calculation of the different cases via DAX.
Like (if you have only 3x different texts A: Total No of Employee, B: 1x Priority ,C: Less than 3 Prio.)
Country | Text |
C1 | A |
C1 | B |
C1 | C |
C2 | A |
C2 | B |
C2 | C |
Perhaps someone know a better solutions?
Proud to be a Super User!
Do you need more help?
Proud to be a Super User!
no, this would be all for the moment. Many thanks
Hi,
do you have some sample data without sensitive information, please? Than it is much easier to help 🙂
Proud to be a Super User!
Sure. It would look like this
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
15 | |
15 |
User | Count |
---|---|
33 | |
26 | |
19 | |
19 | |
17 |