DAX Function counting

[CMSandu]

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

[andhiii079845]

Can you mark a post as a solution. This will be very nice if the post was helpfull for you 🙂

[andhiii079845]

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

[CMSandu]

@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

[andhiii079845]

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? 

[andhiii079845]

Do you need more help? 

[CMSandu]

no, this would be all for the moment. Many thanks

[andhiii079845]

Hi,

do you have some sample data without sensitive information, please? Than it is much easier to help 🙂

[CMSandu · Accepted solution]

Sure. It would look like this