Lookup Function not return the value

Question

I have the two table Global parameter and Remark2(local) . i am trying to get BOM value from Remark2(BOM) in Global parameter table&nbsp; using&nbsp; the below&nbsp;&nbsp;Lookup val-Remark 2 - BomText = &nbsp;//CALCULATE (&nbsp; &nbsp;// FIRSTNONBLANK ( 'Remark2 (local)'[BOM Text (Parameter BOM)], 1 ),&nbsp; &nbsp; //FILTER ( ALL ( 'Remark2 (local)' ), 'Remark2 (local)'[Number] = 'Global Parameters'[Item Code] )//)CALCULATE(SELECTEDVALUE('Remark2 (local)'[BOM Text (Parameter BOM)]),FILTER(ALLNOBLANKROW('Remark2 (local)'[ItemCode]),'Remark2 (local)'[ItemCode]=='Global Parameters'[Item Code]),ALL('Remark1 (local)'))&nbsp;But Lookup function dosn't work . i have attached&nbsp; power bi file reference&nbsp;&nbsp;Power BI File &nbsp;&nbsp;&nbsp;Global Parameter :&nbsp;ItemCode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rev&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OuterFA031375.12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thenna&nbsp;FA031375.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thenna&nbsp;&nbsp;Remark2 (Local)&nbsp;ItemCode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rev&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BOMTEXT(Parameter BOM)FA031375.12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thenna&nbsp;FA031375.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thenna&nbsp;&nbsp;&nbsp;Execpted output:&nbsp;ItemCode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rev&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Outer&nbsp; &nbsp; &nbsp; &nbsp;BOMTEXTFA031375.12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thenna&nbsp; &nbsp; &nbsp; &nbsp;Thenna&nbsp;FA031375.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thenna&nbsp; &nbsp; &nbsp; &nbsp;Thenna&nbsp;Looking for support . thanks in advance .

anonymous · Accepted Answer

Kriekis&nbsp; after the changes Relationshiop it is working . Thank you.

Forum Discussion

Lookup Function not return the value

2 Replies

Related content

Lookup function?

Lookup function

LookUp function ?

Lookup help

Lookup function returns Error