LOOKUPVALUE From One Table to Another Based on Calculated Columns?

[lg1551]

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

[sevenhills]

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:

[sevenhills]

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]

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.

[lg1551]

Still returning blank for me.

This isn't a table visualization. This is literally 2 tables in the model.

[lg1551]

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.

[sevenhills]

Tried this and it worked!

Table3 = GENERATESERIES(1, 10, 1)

Measure

Value - Category 3 = LOOKUPVALUE(Table2[Category], Table2[Category Score], SELECTEDVALUE(Table3[Value]))

Relationships

it worked when I tried

[lg1551 · Accepted solution]

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]

If any of my solution helped, marked my reply also as "Accept as Solution"

[lg1551]

Again, just returning blanks. 

The Category Score is a calculated column, which returns a decimal value, so I have to format it to whole number. I'm wondering if it's trying to use the decimal value in the background, which is why it is returning blanks?