LOOKUPVALUE not reporting all availabe data

CJC_DB Try this:

SN_OEM = MAXX(FILTER('BOM',[IAL Part Number] = 'ANF'[P/N]),[Merged])

If that doesn't work then try doing a Trim operation in Power Query for P/N and IAL Part Number columns.

I wonder if there's perhaps some white space (like a space at the end) in either BOM[IAL Part Number] or ANF[P/N].
   

Just curious if you add a column with a formula like this, what happens?

LookupValueTest = CALCULATE(MAX(BOM[Merged]), FILTER(ALL(BOM),BOM[IAL Part Number] = ANF[P/N]))

Hi CJC_DB , I think i found a solution. 

1. Go to Power Query Editor and select this [P/N] column in the first table and right click and go to transform  - > text transforms -> trim as show in the below table. And do the same for the second table [P/N] column.

2. Click close and apply.

3. Then try the lookup again it should work. I tried my self with one example and it works.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!