RELATED function not working

[Anonymous]

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

[v-jiascu-msft]

Hi @Anonymous,

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

Best Regards,
Dale

[Anonymous · Accepted solution]

@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]

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]

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

[v-jiascu-msft]

Hi @Anonymous,

It seems this issue can't be solved in the forum. If you need more support, I would suggest you file a support ticket here.

Best Regards,
Dale

[CR]

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

[Anonymous]

[CR]

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 ?

[Anonymous]

I'd rather not share the PBIX file, because of confidentiality. Could it be because of I'm using direct query mode? Other than that I don't have a clue.

Or could the file itself be somehow damaged? I've been using it with many versions of PBI Desktop (created in 9/2017)

[CR]

You should be able to use RELATED formula even if you are working in uery mode as said here But I'm not an expert of that topic so I invite you trying to do it though the Query Editor with Merge Queries function.