Identify population based on a slicer

Sample Data Hi there,

I am looking to identify a population of workers based on a Manager selection in a slicer. The data includes a field called 'All Managers in Management Chain' and i want to identify all workers that include the selected Manager, featured in the Management Chain field. This will give me both the direct and indirect reports.

I think its a formula i need - possibly one of the 'Contains' DAX formula or 'Find Text'. Also found the code below but have been unable to get this to work. The formula will ideally flag each worker that has the selected Manager in the Management Chain field so all reports (direct & indirect) are captured.

Hoping you can help.....

Path Contains Tenant original = 
VAR _SLICER =
    SELECTEDVALUE ( 'Table2'[Customer Name] )
VAR _TENANT =
    CALCULATETABLE (
        VALUES ( 'Table1'[Parent Tenant] ),
        FILTER ( ALL ( 'Table1' ), 'Table1'[Parent Tenant] = _SLICER )
    )
VAR _RESULT =
    IF (
        MAX ( 'Table1'[Tenant Name] )
            IN _TENANT
                && MAX ( 'Table1'[Parent Tenant] ) = _SLICER,
        1
    )
RETURN
    _RESULT