Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RELATED function not working

Tables Parent Child joined byt Ref fiel in one to many relationship
I'm creating column in child table called total budget to fetch the budget from the related parent table.
Total budget = RELATED('Parent'[Budget])
 
I get an error: 
The column 'Parent'[Budget] either does not exist or doesn't have a relationship to any table available in current context
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    v-jiascu-msft I tried both measure and column. None of these worked.

     

     

    Solution: I created new PBIX file and copy pasted stuff from the old one. I dislike this kind of solutions, but I had no other choice than spend extra 3 hours recreating the report from scratch.

10 Replies

  • CR's avatar
    CR
    Resolver II
    7 years ago

    Hi Anonymous,

     

    I think the relationship doesn't exist in your PBIX file.

    Please check it is the case by clicking on the button Manage Relationships or by displaying the pan dedicated to the tables.

     

    Regards,,

    CR

      • CR's avatar
        CR
        Resolver II
        7 years ago

        really strange because I did exactly the same as you and it works fine !

         

        I created the relationship then I added a calculated column:

         

         

        Could you share your PBIX to have a look ?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    Maybe you created a measure accidentally rather than a column. Please refer to the snapshot below.

    RELATED-function-not-working

     

    Best Regards,
    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-jiascu-msft I tried both measure and column. None of these worked.

       

       

      Solution: I created new PBIX file and copy pasted stuff from the old one. I dislike this kind of solutions, but I had no other choice than spend extra 3 hours recreating the report from scratch.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

         

        That's too weird. The last possible cause is the version of the Desktop you have. Please upgrade it to the latest version. It's November 2018 for now.

         

        Best Regards,
        Dale