I am currently looking at a transaction list data set where each line shows a location with an amount sold in an adjacent column. I have found out how to rank the values data so I know the amount the top location sold using =MINX ( TOPN ( MIN( 'Rank'[Order] ) ,VALUES (Location [Provider short name] ), CALCULATE ([Sales (Total)] ) ), CALCULATE ([Sales (Total)] ) ) This is useful but I need to retrieve the location which these total sales belong to. I can take my spreadsheet offline and do this separately but would prefer to know how to do this using a new POWER PIVOT measure.