Forum Discussion

mp390988's avatar
mp390988
Post Partisan
1 year ago
Solved

RELATED function not working despite a join

Hi,   I have this model:     I am trying to create a calculated column to bring in the DealerID from the Clients Table into my Payments Table.   But i get an error saying...
Need Help
  • shashiPaul1570_'s avatar
    shashiPaul1570_
    1 year ago

    mp390988  

    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 

shashiPaul1570_'s avatar
shashiPaul1570_
Responsive Resident
1 year ago

Hi mp390988 
RELATED() only works in a calculated column when there is an active 1→ relationship* from Clients (1) to Payments (*) and a single, unambiguous path.

In Model view, please ensure
Clients[ClientID] 1 —— * Payments[ClientID] (Active = Yes).

Then use in Payments

DealerID = RELATED(Clients[DealerID])


If you can’t make that relationship active (or it’s M2M), use:

DealerID = LOOKUPVALUE(Clients[DealerID], Clients[ClientID], Payments[ClientID])


Ensure Clients[ClientID] is unique; otherwise LOOKUPVALUE will error.

Please find this artical for more details.
https://www.datacamp.com/tutorial/power-bi-related-dax-function?utm 

If this solves it, a Kudos 👍 and Accepted Solution ✅ would be awesome!

Thanks 
Shashi Paul