Forum Discussion
Dax Calculated column for indirect reports
Good Morning, I have career history data in a table and I'm trying to calculate how many indirect reports each manager has. I've done this for direct reports but indirect is proving more challeng...
tamerj1
Community Champion
Community ChampionHi Anonymous
Please provide some sample data along with the expected result.
Hi,
Please see below data to illustrate the format. I've got the column for Direct Reports calculating but it's the column for Indirect reports that I'm struggling with.
| Person Number | Manager Person Number | Status Date | Direct Reports | Indirect Reports |
| 1001 | 31/05/2023 | 2 | 7 | |
| 1002 | 1001 | 31/05/2023 | 2 | 1 |
| 1003 | 1001 | 31/05/2023 | 3 | 0 |
| 1004 | 1002 | 31/05/2023 | 0 | 0 |
| 1005 | 1002 | 31/05/2023 | 1 | 1 |
| 1006 | 1003 | 31/05/2023 | ||
| 1007 | 1003 | 31/05/2023 | ||
| 1008 | 1003 | 31/05/2023 | ||
| 1009 | 1005 | 31/05/2023 | ||
| 1010 | 1009 | 31/05/2023 | ||
| 1001 | 30/04/2023 | |||
| 1002 | 1001 | 30/04/2023 | ||
| 1013 | 1001 | 30/04/2023 | ||
| 1004 | 1002 | 30/04/2023 | ||
| 1005 | 1002 | 30/04/2023 | ||
| 1006 | 1013 | 30/04/2023 | ||
| 1007 | 1013 | 30/04/2023 | ||
| 1008 | 1013 | 30/04/2023 | ||
| 1009 | 1005 | 30/04/2023 | ||
| 1010 | 1009 | 30/04/2023 | ||
| 1001 | 31/03/2023 | |||
| 1002 | 1001 | 31/03/2023 | ||
| 1003 | 1001 | 31/03/2023 | ||
| 1004 | 1002 | 31/03/2023 | ||
| 1005 | 1002 | 31/03/2023 | ||
| 1006 | 1003 | 31/03/2023 | ||
| 1007 | 1003 | 31/03/2023 | ||
| 1008 | 1003 | 31/03/2023 | ||
| 1009 | 1005 | 31/03/2023 | ||
| 1010 | 1008 | 31/03/2023 |