Forum Discussion
Return another column based on condition
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 ...
Anonymous
You may use the measure below.
Measure = MAXX ( TOPN ( 1, VendorRate, VendorRate[Price], DESC ), VendorRate[Vendor] )
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.