retrieve next rank up value

[NPIV5]

I have a geography lookup table, date table and a fact table. I have a rank of sales, and I want to retrieve the location of the next store up in the rankings. I have created a measure that retrieves the sales amount of the next store up, but I can't get the location to work. DAX for value is below:

Value of Rank Above =

VAR index = [Rank] - 1

RETURN

CALCULATE (

SUM ( FACT[sales] ),

FILTER ( ALL (geo), index = [Rank] )

)

[amitchandak · Accepted solution]

@NPIV5 , Like ?

location of Rank Above =
VAR index = [Rank] - 1
RETURN
CALCULATE (
Max( FACT[Location] ),
FILTER ( ALL (geo), index = [Rank] )
)

or

location of Rank Above =
VAR index = [Rank] - 1
RETURN
CALCULATE (
Max( geo[Location] ),
FILTER ( ALL (geo), index = [Rank] )
)