How can I find out maximum profit across all the city?

[d_sandip59]

Hi,

I have Profit and City column, now I want to find out city name which has maximum profit. So how can I do that?

[Ashish_Mathur · Accepted solution]

Hi,

Write this measure and place it in a card visual

=LOOKUPVALUE(Data[City],Data[Profit],MAX(Data[Profit]))

Hope this helps.

[d_sandip59]

City with Highest Sales but lowest profit = lookupvalue('Orders'[City],
																									'Orders'[Profit],
																									Min('Orders'[Profit]),
																									'Orders'[Sales],
																									Max('Orders'[Sales])
)

---

@Ashish_Mathur wrote:

Hi,

Write this measure and place it in a card visual

=LOOKUPVALUE(Data[City],Data[Profit],MAX(Data[Profit]))

Hope this helps.

---