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...
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.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        v-jiascu-msft I've been updating the versions of PBI desktop on monthly basis since I started using it in Sep 2017... I always have the up to date version.