PATHCONTAIN COUNT DEPENDANTS

[Anonymous]

I have a table with all the employess and their boss

Emp_ID Boss_Id  PATH             Dependands

1                            1                        5

2                1          1 | 2                   3

3                1          1 | 3                   0

4                2          1 | 2 | 4              2

5                4          1 | 2 | 4 | 5          1

6                5          1 | 2 | 4 | 5 | 6     0

I need to have a column added where it will tell me the total dependants (including direct and indirect), example of calculation needeed above.

Basically I need to count all the files that the pathcointains the Emp_ID of each row.

Thanks in advance,

Sebastián

[foodd · Accepted solution]

Duplicate post.  See URL:   https://community.fabric.microsoft.com/t5/Desktop/PATHCONTAINS-COUNT-Dependants/m-p/458974