Check if a value exist in another table

[Anonymous]

Hi,

i need to check if a value exist in another table that isn't directly relationed.

Relations:

PLM Parts Last <---->    Req Transaction   <-----------> BOM Header

Lookupvalue didn't work

while this worked:

Why? Has lookupvalue some relations limitations?

Thanks

[jdbuchanan71]

It looks like you used a different lookup field between the two. 'PLM Parts Last'[WT Part Number] in the formula, 'PLM Parts Last'[Item Number AX] in the lookup. Does this work for the lookup?

BOMheaderinERP = LOOKUPVALUE ( 'BOM Header'[Item Number]; 'BOM Header'[Item Number]; 'PLM Parts Last'[WT Part Number])

[Anonymous]

Sorry wrong screen.

Value are Item Number and WT Part Number.

BOMheaderinERP = LOOKUPVALUE ( 'BOM Header'[Item Number]; 'BOM Header'[Item Number]; 'PLM Parts Last'[WT Part Number])

Didn't work.

Only the formula works but i don't understand how it works.

[jdbuchanan71]

LOOKUPVALUE doesn't need a relationship at all.  Any chance you can share your .pbix?

[Anonymous]

lookup works but only if value is in the middle table (Req Transaction), if i manually search a PLM Parts Last value in BOM Header  i will find it.

I can't share pbix sorry.

[Anonymous]

This works the same. Only value in middle table.

I think it is a relations problem..