Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

PATHCONTAIN COUNT DEPENDANTS

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

1 ACCEPTED SOLUTION
foodd
Super User
Super User
1 REPLY 1
foodd
Super User
Super User

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.