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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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