RELATED Function with a Direct Query Table

[smag]

I am trying to use the "RELATED" function with a Direct Query Table and alway get and error.  I have the tables related.  Is there an different way to relate to a direct query table?  Will the RELATED fuction work with a direct query?

The error is "either doesn't exist or doesn't have a relationship to any table available in the current context."

[johnt75 · Accepted solution]

RELATED won't work across limited relationships, so if the 2 tables are on different data islands you'll need to use LOOKUPVALUE instead.

[Vipul25]

LOOKUPVALUE also is not working in the direct query mode.