PATH Function/Top Down Reporting Assistance

Hi, TakoTako 

For the first problem you can try the following methods.

Measure:

Measure =
IF (
    SELECTEDVALUE ( Active[Name] )
        <> CALCULATE (
            MAX ( Active[Manager] ),
            FILTER ( ALL ( Active ), [Manager] = SELECTEDVALUE ( Active[Name] ) )
        ),
    0,
    1
)

Then put the measure into the filter of layer 1, 2, 3 and 4 slicer and set it equal to 1.

This way no non-manager names will appear in the layers.

The 2nd problem can be tried as follows.

Measure 2 = 
IF(SELECTEDVALUE(Active[Layer 3])=SELECTEDVALUE(Active[Name]),0,1)

Put it in the filter as well and set it equal to 1. The output at this point is shown in the figure.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.