issue with relationship between tables

[prabhupan]

Hello, 

I have an active relationship between 2 tables, table 1 & 2.

However when i try to have a New Column in table 2 by using "RELATED"  function, it never shows table 1 and i couldnt pick the corresponding value from table 1. 

Any comment on how to solve this ?

[prabhupan]

@v-haibl-msft,

Thanks Herbert. I realised that when i made the last comment. 

Thanks for your time.

Regards

Prabhu

[v-haibl-msft · Accepted solution]

@prabhupan

RELATED function can only be used in the many side. Just think if we use it in the one side, there will be multiple values related to a single value, which one should be returned in only one cell?

Best Regards,

Herbert

[prabhupan]

Hello @v-haibl-msft,

Its many to one & the related column is in the One side. 

Regards

Prabhu

[v-haibl-msft]

@prabhupan

Is the relationship ‘many to one’ or ‘one to one’? If it is ‘many to one’, did you create the related column in the ‘many’ side?

I tried on Feb 2017 version of Power BI Desktop but cannot repro the same issue as you.

Best Regards,

Herbert