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.

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        RELATED needs a row context to work. Do you have a row context when you use this function above? I can't even tell from what you posted what it is you're trying to achieve...

         

        Are you maybe trying to add the rate to each row in the fact table by creating a calculated column? That would be a VERY BAD IDEA.