Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

LOOKUPVALUE not returning result for matching data

Hello,    I am trying to use the LOOKUPVALUE function across two tables to return a result of "Published" or "Unpublished." In data table 'Sales Data' I have a cell value 401211_US - Ferguson that ...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

it looks like the result is correct. the length of 401211_US 0 Ferguson is 20 in both tables.

Could you pls provide the sample data (not in screenshot) and the expected output?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It is not the expected result as the DAX expression should produce a result of "published." I was able to produce the correct result by changing the relationship between tables to [Mat_Salsify] and [Mat_Distributor]. It would still be good to know why the DAX expression did not produce the desired result before changing the relationship.