PATHCONTAIN COUNT DEPENDANTS

Question

I have a table with all the employess and their boss&nbsp;Emp_ID Boss_Id&nbsp; PATH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dependands1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 52&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 | 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;33&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 | 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 | 2 | 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 | 2 | 4 | 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 | 2 | 4 | 5 | 6&nbsp; &nbsp; &nbsp;0&nbsp;I need to have a column added where it will tell me the total dependants (including direct and indirect), example of calculation needeed above.&nbsp;Basically I need to count all the files that the pathcointains the Emp_ID of each row.&nbsp;Thanks in advance,Sebastián

foodd · Accepted Answer

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

Forum Discussion

PATHCONTAIN COUNT DEPENDANTS

1 Reply

Related content

Circular dependency

Counting nulls

Dax query dependency

dependent slicers

RLS Exclusionary Role with NOT PATHCONTAINS() Not Filtering Data