Measures need to replace by Table joins

Anonymous 

You can use the following DAX measure:

Measure =
VAR SelectedTotalValue =
    SELECTEDVALUE ( Table[Total] )
VAR TotalValue =
    SUM ( Table1[Total] )
RETURN
    CALCULATE (
        MAX ( Table[Value] ),
        FILTER ( Table, SelectedTotalValue = TotalValue )
    )

Here, Table is the one that you have created and Table1 is the table from which you are calculating the sum.

Please let me know if this didn't work.