Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
andrew_k
Helper I
Helper I

Need to return first value when LOOKUPVALUE returns multiple values

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

 

andrew_k_1-1736777712454.png

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Excellent. Thanks Greg!

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!