Calculate distinct based on the two columns

Hi,

NewColumn =
VAR MyTeam = 'Table'[Team]
VAR MyID = 'Table'[ID]
VAR MyTeamIDWins =
    CALCULATE (
        COUNTROWS ( FILTER ( 'Table', 'Table'[Team] = MyTeam && 'Table'[ID] = MyID ) ),
        'Table'[Result] = "Win"
    )
VAR MyTeamIDLosses =
    CALCULATE (
        COUNTROWS ( FILTER ( 'Table', 'Table'[Team] = MyTeam && 'Table'[ID] = MyID ) ),
        'Table'[Result] = "Loss"
    )
RETURN
    SWITCH (
        1 * ( MyTeamIDWins > 0 ) + 2 * ( MyTeamIDLosses > 0 ),
        1, "Win",
        2, "Loss",
        3, "Multiple"
    )

Regards

How about this?

Desired Report =
VAR Results =
    CALCULATETABLE (
        VALUES ( Table1[Result] ),
        ALLEXCEPT ( Table1, Table1[Team], Table1[ID] ),
        Table1[Result] <> "No Result"
    )
RETURN
    SWITCH (
        TRUE (),
        COUNTROWS ( Results ) = 0, "No Result",
        COUNTROWS ( Results ) = 1, Results,
        COUNTROWS ( Results ) > 1, "Multiple"
    )

Thanks for your reply and solution for Jos_Woolley  and @AlexisOlson and sorry for the late reply. 

Both solutions are working well.