RELATED not working even with 1:1 relation in place

[EllenW]

Hello,

I'm going through my power BI file and looking where I can replace LookupValue with the Related function. Now I'm stuck on the following: one table is a DirectQuery named Financials in which I have created the CodeYearKey with which I've set a relation to the Priority page. Priority is based on the The List (a DirectQuery) and also has a CodeYearKey. I want to add some columns of the Financial table to the Priority table and wanted to use the Related function for this. Scores consists out of selected columns from the Financials table. Priority page also has one column using a related function which looks at a column of the Scores table, but because it has some sensitive data I have hidden it. Please see screenshots for more information. I have set up one to one relations, but the Related function in the Priority table looking at the Financials table is not working. 

[Anonymous · Accepted solution]

@EllenW 

Because 'Financials' is a direct query table, you can only refer to columns in the same table. 

Please check the limitations of direct query mode: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

• Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions.

Try use measure as the alternative, but you would need to use table visual to see the table.

Measure = MAX('Financials'[Flag])

Best regards

Paul Zheng

[Anonymous]

I am not sure about it but i think it is because of relationship.

Relatedtable works for one to many,

Related works for Many to one.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.