Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Userelationship to return specific text/value

Hi there,    Got some great help with a prior post where the foundational issue is very similar. The main difference between the two (I believe) is the desired output here is a Text field whereas p...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak Thanks! Have not created a measures in this case. Just a log of transactions. In the table I've simply added those fields outlined. Ideally, the customerID column would have no blanks in it, but given the active/inactive relationships they do. Does that make sense?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You can make inactive as active using a measure only.

Blank can be because of that of missing values in VIP Table

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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)