Need to return first value when LOOKUPVALUE returns multiple values

Question

Hi All&nbsp;I have a table in my Power BI report which contains a Companyname and Symbol.I want to write a DAX measure where I pass in the Companyname and it returns the Symbol.I pass in the Companyname via another measure called [Selected Stock]. This works.&nbsp;This is my current DAX:Selected Stock Symbol =LOOKUPVALUE(&nbsp; DimCompanies[Symbol],&nbsp; DimCompanies[Companyname],&nbsp; [Selected Stock])The problem is that the Companyname is not unique.So in the instance of 'Alphabet Inc.' my DAX returns a blank as there are multiple values (GOOGL and GOOG).In this instance I want to return the first value it finds but am stuggleing with the code. I have tried using a combination of Firstnonblank and Filter but am still stuck.&nbsp;Any help would be great.Andrew&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Accepted Answer

andrew_k&nbsp;Use MINX( FILTER( ... ), ... ) instead of LOOKUPVALUE.

Forum Discussion

Need to return first value when LOOKUPVALUE returns multiple values

2 Replies

Related content

LOOKUPVALUE with multiple return values

LOOKUPVALUE() return first of multiple matches

Lookupvalue Returning an Error

LOOKUPVALUE returns blank value

LOOKUPVALUE And Return Multiple Values Horizontally