Forum Discussion
Gender split pay per Quartile
I have the following dataset. This is for 2 employees. I have n number of employees. Based on this, I need to find the percentage of Male and Female in each quartile (totally 4 quartiles 0-25% , 25-50%, 50-75%, 75-100%). anyone can please help to solve this in DAX.
| 202301 | 1 | 47000 | M |
| 202302 | 1 | 47000 | M |
| 202303 | 1 | 47000 | M |
| 202304 | 1 | 47000 | M |
| 202305 | 1 | 47000 | M |
| 202306 | 1 | 47000 | M |
| 202307 | 1 | 47000 | M |
| 202308 | 1 | 47000 | M |
| 202309 | 1 | 47000 | M |
| 202310 | 1 | 47000 | M |
| 202311 | 1 | 47000 | M |
| 202312 | 1 | 47000 | M |
| 202401 | 1 | 47000 | M |
| 202402 | 1 | 47000 | M |
| 202403 | 1 | 47000 | M |
| 202404 | 1 | 47000 | M |
| 202405 | 1 | 47000 | M |
| 202406 | 1 | 47000 | M |
| 202301 | 2 | 50000 | F |
| 202302 | 2 | 50000 | F |
| 202303 | 2 | 50000 | F |
| 202304 | 2 | 50000 | F |
| 202305 | 2 | 50000 | F |
| 202306 | 2 | 50000 | F |
| 202307 | 2 | 50000 | F |
| 202308 | 2 | 50000 | F |
| 202309 | 2 | 50000 | F |
| 202310 | 2 | 50000 | F |
| 202311 | 2 | 50000 | F |
| 202312 | 2 | 50000 | F |
| 202401 | 2 | 50000 | F |
| 202402 | 2 | 50000 | F |
| 202403 | 2 | 50000 | F |
| 202404 | 2 | 50000 | F |
| 202405 | 2 | 50000 | F |
| 202406 | 2 | 50000 | F |
No RepliesBe the first to reply