Filtering based on related table

Hi NithinBN 

You can create the following measure

Measure =
VAR a =
    CALCULATETABLE (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( Relation ),
                CONTAINSSTRING ( [Employee-1], "M-" ) && CONTAINSSTRING ( [Employee-2], "D-" )
            ),
            [Employee-2]
        ),
        CROSSFILTER ( 'Relation'[Employee-1], Employee[EmployeeID], NONE )
    )
RETURN
    CALCULATE (
        SUM ( Employee[Hours] ),
        FILTER ( Employee, [EmployeeID] IN a ),
        CROSSFILTER ( 'Relation'[Employee-1], Employee[EmployeeID], NONE )
    )

Output

Best Regards!

Yolo Zhu

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