Sure. It would look like this
Solution SageThank 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
Solution SageI 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?
Solution SageDo you need more help?
