Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Link reference table twice without duplicating data.

Given the following tables   Trip ID FromLocationID ToLocationID   Location ID Name City   I want to be able to use the location name for both the From and To in Trip but you can't create...
Need Help
DataInsights's avatar
DataInsights
Super User
3 years ago

Anonymous,

 

You can create an inactive relationship and use the DAX function USERELATIONSHIP to activate the inactive relationship. In this example, the active relationship would be between Location[ID] and Trip[FromLocationID]. The inactive relationship would be between Location[ID] and Trip[ToLocationID]. Example measure:

 

Count Trip ID - To Location =
CALCULATE (
    COUNT ( Trip[ID] ),
    USERELATIONSHIP ( Location[ID], Trip[ToLocationID] )
)