Bronco Off-Roadeo Texas

 

Power BI RANKX DAX Function

Power BI examples using the RANKX() DAX function.

TravelerRank = RANKX(ALL(Traveler),Traveler[Traveler Name],,DESC,Dense)

Traveler Rank by Air Tickets =

VAR MeasureValue = [Air Tickets]

VAR MaxRank = CALCULATE(MAX(Traveler[TravelerRank]),REMOVEFILTERS())

VAR LookupTable = ADDCOLUMNS(ALL(Traveler)

    ,"@Total", [Air Tickets] * MaxRank + Traveler[TravelerRank]

)

VAR CurrentName = SELECTEDVALUE ( Traveler[Traveler Name] )

VAR CurrentNameRanked = RANKX ( ALL ( Traveler), Traveler[Traveler Name], CurrentName, DESC, DENSE )

VAR CurrentValue = MeasureValue * MaxRank + CurrentNameRanked

VAR retval = RANKX(LookupTable,[@Total],CurrentValue,,Dense)

RETURN retval

Source: https://learn.microsoft.com/en-us/dax/rankx-function-dax