Forum Discussion
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 '...
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!
Add this measure in Table 1
Value - Category =
CALCULATE(MAX('Table2'[Category]), 'Table2'[Category Score] = SELECTEDVALUE(Table1[Value]))
For the table visual, you need to enable this setting
Output:
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!
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.