Forum Discussion
DAX help for calculating head count.
Hi experts,
Please help
Need to calculate headcount based on the manager and director tags.
If the employee is either a manager or director, then we need to calculate the number of employees allocated to him.
| Input | |||
| Employee ID | Designation | Director ID | Manager ID |
| 1 | Supervisor | 4 | 3 |
| 2 | Supervisor | 4 | 3 |
| 3 | Manager | 5 | |
| 4 | Director | ||
| 5 | Director |
| Output | |
| Employee ID | Headcount |
| 3 | 2 |
| 4 | 2 |
| 5 | 1 |
