Show me the name of the MIN/MAX value

[I_LOVE_POWER_BI]

Hi folks, My problem appears to be very simple: 

I have a MIN and a MAX value - easy. But how can I show the name of the category of the MAX/MIN value? Here an example:

So depending on the MIN/MAX value in column "Weight", I want the column value in "Receipe" to appear.

Thanks!!

[CNENFRNL · Accepted solution]

RECIPE Max =
MAXX( TOPN( 1, 'DATA TABLE', 'DATA TABLE'[Weight] ), 'DATA TABLE'[RECIPE] )

RECIPE Min =
MAXX( TOPN( 1, 'DATA TABLE', 'DATA TABLE'[Weight], 1 ), 'DATA TABLE'[RECIPE] )

[amitchandak]

@I_LOVE_POWER_BI , Try meausre like

Switch(true(),
Max(Table[Receipe]) = "Orange Cake", min(Table[Weight]),
Max(Table[Receipe]) = "Apple Cake", max(Table[Weight])
)

or

sumx(values(Table[Receipe]),
Switch(true(),
Max(Table[Receipe]) = "Orange Cake", min(Table[Weight]),
Max(Table[Receipe]) = "Apple Cake", max(Table[Weight])
)
)

[I_LOVE_POWER_BI]

Thanks @amitchandak ,

I didn't explain it well enough, sorry. The two cakes are just an example out of a lot of different variables. I need it to be dynamically, not based on those two fixed values.

So the measure has to first lookup the MIN value and then show the name of the respective receipe. How to da that?

[amitchandak]

@I_LOVE_POWER_BI ,Can you share sample data and sample output in table format?

[I_LOVE_POWER_BI]

@amitchandak thanks for your kind support. So here is the example, which shows how easy my request actually is: 

I have a card in which I want to show "Orange Cake", because it is the Max-value. As you can see in the filter ribbon, this must be dynamic, because depending on the receipe I choose, I want to see which is the receipe name with the highest value. 

Thanks again!