Need help with userelationship to display label text

[GKrishnan]

Hi,

I am having an issue with using inactive relationship to display a label text. As in the image you can the see text displayed both for performance and potential is same even though the skeys are different. One of the relationship is kept active and other is inactive, direction of filter is single.

DAX 

current_potential_label_nm_measure = CALCULATE(

    MAX('MODEL Dim_Rate_Label'[rate_label_nm]),

        USERELATIONSHIP(

            'MODEL Fact_Performance'[current_potential_label_rt_skey],

            'MODEL Dim_Rate_Label'[rate_label_skey]

        )

)

I have tried the following as well but doesn't return expected results

current_potential_label_nm_measure = CALCULATE(

    MAX('MODEL Dim_Rate_Label'[rate_label_nm]),
    CALCULATETABLE(
        'MODEL Fact_Performance'

        USERELATIONSHIP(

            'MODEL Fact_Performance'[current_potential_label_rt_skey],

            'MODEL Dim_Rate_Label'[rate_label_skey]

        ))

)

Any thoughts how to fix this? 

[GKrishnan]

Sorry I can't share the file due to sensitive data. But I got it working unfortunately performance is too slow as I had to add 10 relationships. So resorted back to using lookup.

[xifeng_L]

I need to see the model relationships and the tables that each field on the matrix belongs to, can you provide the pbix file?