Return Field Value using Max of an Existing Measure (IE: showing the name of league winner)

[PaulVanS]

Good morning,

In order to learn Power BI, I am creating an App that analyses the results of my local poker league.  

My data model can be seen in the attached image

I have created a measure that SUMS the points earned by players during the 2nd season of our local poker league with the measure:

Season Total Points = SUM(Results_Final[Points])

If I create a table that lists the players and the measure and then filter by season (Name), I can see the results are correct.

I would like to create (I assume a Measure) have a table that has the dimension [Name], therefore showing all the seasons that have occured so far, and in the second column I would like to show the winner of that season (so therefore to effectively find the [Player] with the maximum Season Total Points from the measure defined above).  In the instances of a tie, the winner can be just taken from the first alphabetically of the Players with the most total points.

Please can someone help me with how I would achieve this? 

[Greg_Deckler]

@PaulVanS This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

[PaulVanS · Accepted solution]

Hi @Greg_Deckler,

Thank you very much for the reading.  Will definitely take a deep dive into it a bit later.  I have actually managed to achieve the results using the following formula:

Season Winner = FIRSTNONBLANK(TOPN(1,VALUES(Results_Final[Player]),[Season Total Points]),1)

That said, once again thank you very much for your response and blog!

Kind regards,

Paul