Forum Discussion
RELATED function not working despite a join
Glad that helped!
Yes, LOOKUPVALUE is a good alternative when RELATED doesn’t behave as expected, especially if the relationship setup is tricky. Just make sure the Clients[ClientID] column is unique, so you always get a single match.Happy reporting, and if this solved your issue, please don’t forget to give a Kudos 👍 and mark it as Accepted Solution ✅ so others can benefit too.
Thanks
Shashi Paul
Hi mp390988
That is a limited relationship between DQ and import and what you're experiencing is a known limitation.
Model relationships in Power BI Desktop
Ah I see, thanks danextian .
So I will use shashiPaul1570_ suggestion of LOOKUP instead then.Glad that helped!
Yes, LOOKUPVALUE is a good alternative when RELATED doesn’t behave as expected, especially if the relationship setup is tricky. Just make sure the Clients[ClientID] column is unique, so you always get a single match.Happy reporting, and if this solved your issue, please don’t forget to give a Kudos 👍 and mark it as Accepted Solution ✅ so others can benefit too.
Thanks
Shashi PaulHave you tried LOOKUPVALUE? Did it work? The last time I tested it with a limited relationship, it didn't work.
