Forum Discussion
Unable to pass a variable using LOOKUPVALUE
I'm currently trying to pull a value from a different row in a table using the LOOKUPVALUE command but I'm encountering a problem. Landmark =
VAR trailerid = 'Table'[Trailer ID]
RETURN
LOOKUPVA...
Are you trying to use LOOKUPVALUE on the dimension table and the values are on the many side of the relationship? If yes, then you should use an Iterator like FILTER & RELATEDTABLE to get a list of all the values that are related to the current row in the table.