Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Lookup Function not return the value

I have the two table Global parameter and Remark2(local) . i am trying to get BOM value from Remark2(BOM) in Global parameter table  using  the below    Lookup val-Remark 2 - BomText =  //CALCUL...
"Need Help"
Help me
Help me please
  • Anonymous's avatar
    Anonymous
    3 years ago

    Kriekis  after the changes Relationshiop it is working . Thank you.

Kriekis's avatar
Kriekis
Frequent Visitor
3 years ago

Hi,

You can use dax expressions below.

But in general Your model is good example which shows that usage of many-to-many relationships isn't good idea.

So many-to-many is the main problem here.

 

Lookup val-Remark 2 - BomText =
VAR _itemCode = 'Global Parameters'[Item Code]
RETURN
CALCULATE(
  LOOKUPVALUE(
    'Remark2 (local)'[BOM Text (Parameter BOM)],
    'Remark2 (local)'[Number],
    _itemCode
  ),
  CROSSFILTER('Remark2 (local)'[Item Code], 'Remark1 (local)'[Item Code], None) // disables relationship
)
 
/Andris