Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
@Anonymous
You may take a look at the link below
https://www.sqlbi.com/articles/userelationship-in-calculated-columns/
@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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |