topic DAX Function counting in DAX Commands and Tips

DAX Function counting

CMSandu — Mon, 27 Feb 2023 11:59:00 GMT

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

Re: DAX Function counting

andhiii079845 — Mon, 27 Feb 2023 12:01:56 GMT

Hi,

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

Re: DAX Function counting

CMSandu — Mon, 27 Feb 2023 12:08:35 GMT

Sure. It would look like this

Re: DAX Function counting

andhiii079845 — Mon, 27 Feb 2023 12:30:42 GMT

Thank you, measure can be:

Matrix:


COUNT = COUNTA('Table'[Priority Name])

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

Re: DAX Function counting

CMSandu — Mon, 27 Feb 2023 12:44:57 GMT

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

Re: DAX Function counting

andhiii079845 — Mon, 27 Feb 2023 13:11:05 GMT

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?

Re: DAX Function counting

andhiii079845 — Mon, 06 Mar 2023 08:59:52 GMT

Do you need more help?

Re: DAX Function counting

CMSandu — Mon, 06 Mar 2023 09:32:41 GMT

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

Re: DAX Function counting

andhiii079845 — Mon, 06 Mar 2023 09:43:40 GMT

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