Return another column based on condition

[Ips1984]

I am looking to return highest value  for city and corresponding vendor in my formula 

City  Vendor  Price

A         1           30

A         2           50

A         3          100

B         1            35

B          2           40

C         1            60

Measure

Highest Price = CALCULATE(MAX(VendorRate[Price]),ALLEXCEPT(VendorRate[City]) Its populating highest price but not the vendor. I am using Top N in the visual filter but its displaying incorrectly Thanks you in Advance

[v-chuncz-msft · Accepted solution]

@Ips1984 

You may use the measure below.

Measure =
MAXX ( TOPN ( 1, VendorRate, VendorRate[Price], DESC ), VendorRate[Vendor] )

[ramsyBI]

You can use Rank funtion in mesure to calculate rank based on condition then just filter where rank is 1 or create a new column in the table with Rank function and then apply filter where it is 1.

[parry2k]

@Ips1984 add a unique identifier like index column using power query and then use your measure to return index. once you have index, you can get whatever column you need for that row price/vendor etc.