Am trying to find winner with most number of wins against each season. Simplified data is as below

[subhashg]

Season    Winner

2008        A

2008        A

2008        B

2008        C

2008        C

2008        A

2009        B

2009        B

2009        C

2009        D

Answer should look like

Season   Top Winner

2008       A

2009       B

[amitchandak · Accepted solution]

@subhashg , Create a measure

rankx(filter(allselected(Table[Year], Table[winner]), [year] =max([year])), calculate(count(Table[winner])))

and filter on Rank =1 at visual level