25 Days of DAX Fridays - Day1

25DaysDAX_Day1.dax

Day1 Answer = 


var _result =
MAXX(
    TOPN( 1,                                            // return top 1
        VALUES( tournaments_standings[team_name] ),     // iterate over tournaments_standings table
        CALCULATE(          
            COUNTROWS( tournaments_standings ),         // count all rows in table
            tournaments_standings[position] = 1         // where position is first place
        ) , 
    DESC                                                // sort descending
    ) , 
    [team_name]                                         // return the max value of the [tean_name] column
)

RETURN
    _result