Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
CMSandu
Frequent Visitor

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

1 ACCEPTED SOLUTION

Sure. It would look like this Capture.JPG

View solution in original post

8 REPLIES 8
andhiii079845
Solution Sage
Solution Sage

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




andhiii079845
Solution Sage
Solution Sage

Thank you, measure can be:

andhiii079845_1-1677500803063.png

 

Matrix:
andhiii079845_0-1677500768041.png


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

or

COUNTBLANK = COUNTBLANK('Table'[Priority Name])

Other question is that you want like this:

Count of priorityCount of employee
Empty2
11
22
31
40
51

 





Did I answer your question? Mark my post as a solution!

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 thanksCapture.JPG

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.)

CountryText
C1A
C1B
C1C
C2A
C2B
C2C

Perhaps someone know a better solutions? 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Do you need more help? 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

andhiii079845
Solution Sage
Solution Sage

Hi,

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Sure. It would look like this Capture.JPG

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.