Return Product Name that has the highest unit price

[AmritaOS]

hello

i am looking to return the name of the product that has the highest unit proce. 

product 1 , price 20

product 2 , price 10

product 3 , price 5

so i want to return the product name that has the max unit price = Product 1

how do i do this?

thanks!!

Amrita

[bcdobbs · Accepted solution]

Try something like this:

VAR MaxPrice = 
	MAX(Table[Price])

VAR ProductNames = 
	CALCULATE (
		CONCATENATEX(
			VALUES(Table[Product]),
			Table[Product],
			", " ),
	Table[Price] = MaxPrice
	)
	
RETURN ProductNames

[AmritaOS · Accepted solution]

i did the below and it worked - nice and simple!

Most Expensive Product = LOOKUPVALUE(Products[ProductName],Products[UnitPrice],MAX(Products[UnitPrice]))

[bcdobbs]

In your test case that works fine. Just be aware that LOOKUPVALUE will return an error if more than one product has the same max price unless you specify an alternative result. @calerof  solution will return BLANK in such cases. I included CONCATENATEX as it will return a list of all max prices.

[calerof]

Hi @AmritaOS ,

You could also use this code:

Highest Price = 
CALCULATE(
    SELECTEDVALUE(Table_20211202[Product Name]),
    Table_20211202[Unit Price] = MAX(Table_20211202[Unit Price])
)

And get this result:

Hope it helps.

Regards,

Fernando

[bcdobbs · Accepted solution]

Try something like this:

VAR MaxPrice = 
	MAX(Table[Price])

VAR ProductNames = 
	CALCULATE (
		CONCATENATEX(
			VALUES(Table[Product]),
			Table[Product],
			", " ),
	Table[Price] = MaxPrice
	)
	
RETURN ProductNames

[AmritaOS]

thank you yes this is definatelly way better and future proofs the measure!