Calculated Column: RELATED & USERELATIONSHIP

[Anonymous]

Hi,

I had a custom column like this:

Column = LOOKUPVALUE(TABLE1[NAME], TABLE1[ID], RELATED(TABLE2[ID]))

This worked fine, because I had an active relationship between Table1 & Table2.

Now this active relationship needs to be an inactive relationship, and the related function can't find TABLE2 anymore.

I've tried different things but it seems impossible to use RELATED together with USERELATIONSHIP.

I've also tried to use a LOOKUPVALUE instead of the RELATED, but TABLE2[ID] has multiple rows for each ID. 

Any suggestions?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the link below

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

[Greg_Deckler]

I have tended to have better luck with RELATEDTABLE over RELATED so you might try that in conjunction with USERELATIONSHIP.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Posting sample data and your data model would greatly help.