Forum Discussion
LOOKUPVALUE From One Table to Another Based on Calculated Columns?
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!
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.
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
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?
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!
If any of my solution helped, marked my reply also as "Accept as Solution"
