Userelationship to return specific text/value

amitchandak I think that's what I'm looking for... a measure to populate the customerID column. The customerID column is blank in some places because of the inactive/active relationship. For instance, if you look at the first row customerID 9 is in the VIP table, but yet not populated in the customerID column. Some things I've tried are below:

New Customer ID = //this measurement is needed to address the active/inactive relationship pair in our whales_lookup table to transfers table
    VAR to_address = 
        CALCULATE(
            Max(VIP[customerID]),
                USERELATIONSHIP(VIP[customerID],transactions[to_address]) // this creates a temporary and simultaneous active relationship between whales and to address
        )
    VAR from_address = 
        CALCULATE(
            Max(VIP[customerID]),
            USERELATIONSHIP(VIP[customerID],transactions[from_address]) // this creates a temporary and simultaneous active relationship between whales and from address
        )
        RETURN

        max(to_address, from_address)