USERELATIONSHIP together with SELECTEDVALUE or RELATED

[simormate]

I have two relationships between two table: a contracts table and a price plans table. The active one is between the current price plan of the contract, and the inactive one is between the price plan at the beginning of the contract (users are allowed to shift between price plans during the contract). I would like to have a calculated column in my contract table showing the name of the first price plan. These codes do not work:

First Price Plan =

CALCULATE ( RELATED ( PricePlans[Price Plan] ), USERELATIONSHIP ( Contracts[First Price Plan ID], PricePlans[Price Plan ID]))

First Price Plan =

CALCULATE ( SELECTEDVALUE ( PricePlans[Price Plan] ), USERELATIONSHIP ( Contracts[First Price Plan ID], PricePlans[Price Plan ID]))

Why do these codes not work and what could work?

[simormate]

An article from sqlbi.com explaining the issue and solutions: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

[amitchandak · Accepted solution]

@simormate , USERELATIONSHIP  can change the relationship in the case of measure. In the case of the column, you can simply use your choice of joins in the filter.

example

First Price Plan = minx (filter(PricePlans,Contracts[First Price Plan ID]= PricePlans[Price Plan ID]) PricePlans[Price Plan] )

refer : https://www.youtube.com/watch?v=czNHt7UXIe8

[daxer-almighty]

You are in trouble here. USERELATIONSHIP is not able to change the connection between tables when you use it in a calculated column. Only the active relationship is always active when you define a calculated column. There are articles about this behaviour on www.sqlbi.com. 

What you can do is use LOOKUPVALUE instead.