Forum Discussion

simormate's avatar
simormate
Frequent Visitor
5 years ago
Solved

USERELATIONSHIP together with SELECTEDVALUE or RELATED

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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

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.