Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Direct Query - related function

Hi Expert

 

i cannot get my related table calculated column to work when using direct query in my Power Bi model.. Is this possible? or is there a work around?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    According to http://dax.guide/related, RELATED is supported in DirectQuery:

    RELATEDTABLE, on the other hand, works only in measures in DirectQuery:

    So, if you can't get it to work in the right context, it means you're doing something wrong.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    According to http://dax.guide/related, RELATED is supported in DirectQuery:

    RELATEDTABLE, on the other hand, works only in measures in DirectQuery:

    So, if you can't get it to work in the right context, it means you're doing something wrong.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      that is what i cannot work out. Exchnage rate table relationship to FACT table is store id to store id.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        error message when using related