Forum Discussion
Solved
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 mo...
Sure. It would look like this
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?
Do you need more help?