Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |