Forum Discussion
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 'Category Column' value from Table 2 so that it appears next to the Value in Table 1 that matches the 'Category Score' from Table 2. When I do a LOOKUPVALUE it returns blank. What's the workaround?
| Table 1 | I want this result in Table 1. | Table 2 | |||
| Value | Category | Category | Category Score | ||
| 1 | A | 2 | |||
| 2 | A | B | 5 | ||
| 3 | E | C | 8 | ||
| 4 | D | 10 | |||
| 5 | B | E | 3 | ||
| 6 | |||||
| 7 | |||||
| 8 | C | ||||
| 9 | |||||
| 10 | D |
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!
9 Replies
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:
Still returning blank for me.
This isn't a table visualization. This is literally 2 tables in the model.
Table 1 is a calculated table with the "Value" column generated using "Generate Series"
Table 2 is a table with the Category dimension and a calculated column for Category Score.
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.
