How to show a value (string) of a column based on the minimum of an other column?

[matthijs-eigen]

Hello everyone, 

I have a question. I have a table that looks like this:

 Value1 Value2

A          1 

B          3

C         4

D          2

A          1

B           2

Based on the minimum in column 'Value2', I want to show the Value1 in a card in PowerBI. But i don't know how to do it?

Kind regards,

Matthijs

[Greg_Deckler · Accepted solution]

@matthijs-eigen Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

In your case:

Measure =
  VAR __Min = MIN([Value2])
RETURN
  MAXX(FILTER('Table',[Value2]=__MIn),[Value1])

[amitchandak]

@matthijs-eigen , Try Measure like

firstnonblankvalue(Table[Value2], min(Table[Value1]))

or

measure =
var _min = minx(Table, Table[Value2])
return
calculate( min(Table[Value1]), filter(Table, Table[Value2]) =_min)