Forum Discussion
DAX Function counting
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
Sure. It would look like this
8 Replies
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 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?
Hi,
do you have some sample data without sensitive information, please? Than it is much easier to help 🙂
Sure. It would look like this
Can you mark a post as a solution. This will be very nice if the post was helpfull for you 🙂
