Forum Discussion

lg1551's avatar
lg1551
Icon for Resolver II rankResolver II
3 years ago
Solved

LOOKUPVALUE From One Table to Another Based on Calculated Columns?

Table 1 has a 'Generate Series' calculated column which provides a list of values. Table 2 has a 'Category Column' and the calculated column for the 'Category Score'.   I am trying to lookup the '...
Need Help
  • lg1551's avatar
    lg1551
    3 years ago

    I figured it out. It was the decimal from Category Score that was the culprit. I wrapped that calculated column in a "FIXED" function and it works fine now. Thank you for troubleshooting with me!

sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
3 years ago

If you have the relationship like this, you can try ... 

 

Measure:

Value - Category 2 = LOOKUPVALUE(Table2[Category], Table2[Category Score], SELECTEDVALUE(Table1[Value]))

It works the same way!

lg1551's avatar
lg1551
Icon for Resolver II rankResolver II
3 years ago

Yes, I have the relationship between the two tables. I've tried RELATED, LOOKUPVALUE, and the first approach you posted. None of the approaches gives an error, they all three just return blank. The Category value doesn't come over. Both the "VALUE" column and the "Category Score" columns are formatted as whole number. I don't understand what the issue is.