Linking Measure to Column in another Table

Hi superbird 

Divide the average by a thousand and round it off to the nearest integer and then multiply it by 1000. Use that as lookup value.

AverageThousands =
LOOKUPVALUE (
    Table2[Output],
    Table2[Value], ROUND ( DIVIDE ( [Average], 1000 ), 0 ) * 1000
)

Value in table2 should always be unique for the lookup to work correctly.

thanks so much, that works 🙂
what if i have multiple output columns in table 2 - would i need to create a lookupvalue for each column? there is no way to create a relationship to save having to create multiple lookupvalues?