Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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         ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous 

     

    You may use the measure below.

    Measure =
MAXX ( TOPN ( 1, VendorRate, VendorRate[Price], DESC ), VendorRate[Vendor] )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous 

 

You may use the measure below.

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