Employee Hierarchy

Hi,

I have a workaround to meet your requirement.

Please try to create a name slicer table first:

Name Slicer = DISTINCT(SELECTCOLUMNS('Table',"Name Slicer",'Table'[Name]))

Then create this column:

Column = SWITCH(true,'Table'[Name]='Table'[1],1,'Table'[Name]='Table'[2],2,'Table'[Name]='Table'[3],3,'Table'[Name]='Table'[4],4)

Try this measure:

Measure = IF(MAX('Table'[Column])>CALCULATE(MAX('Table'[Column]),FILTER(ALLSELECTED('Table'),'Table'[Name]=SELECTEDVALUE('Name Slicer'[Name Slicer]))),1,0)

Apply this measure to the table visual.

When you choose one name in name slicer, the result shows all employees under him/her:

Here is my test pbix:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi