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.

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?