Need to return first value when LOOKUPVALUE returns multiple values

[andrew_k]

Hi All

• 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.

This is my current DAX:

Selected Stock Symbol =
LOOKUPVALUE(
  DimCompanies[Symbol],
  DimCompanies[Companyname],
  [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.

Any help would be great.

Andrew

[Greg_Deckler · Accepted solution]

@andrew_k Use MINX( FILTER( ... ), ... ) instead of LOOKUPVALUE.

[andrew_k]

Excellent. Thanks Greg!

MINX( FILTER(DimCompanies, [Companyname] = [Selected Stock]),[Symbol])