How to combine the max column and other related columns to a table

[Kelly_Zhu]

Hi Everyone,

I have a problem to combine the two table , not in query.

Below is an example.

Any help is much appreciated. Thank you in advance! 

[Zubair_Muhammad · Accepted solution]

Hi @Kelly_Zhu

You can use this Measure to get "RELATEDF"

RelatedF =
VAR MaxE =
    MAX ( Table1[E] )
RETURN
    CALCULATE (
        VALUES ( Table1[F] ),
        FILTER ( ALLEXCEPT ( Table1, Table1[Group] ), Table1[E] = MaxE )
    )