Forum Discussion
Calculated Column: RELATED & USERELATIONSHIP
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. ...
Anonymous
You may take a look at the link below
https://www.sqlbi.com/articles/userelationship-in-calculated-columns/
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.