Relationship two column in the same table to lookup table

[Anpham2812]

Dear all,

Im new to PowerBi & these relationship things, hope to have your kind adivce on this problem.

The first relationship is Destination to Full code, the second is Origin to Full code, 

When i put it into Matrix table, it shows correct city of Destination but incorrect of Origin.

                         

Any comments would be highly appreciated.

Thanks

[Anonymous]

@Anpham2812 

You can only have one active relationship between tables, for inactive relationship please refer to the dax function.

USERELATIONSHIPP: https://docsmicrosoftt.com/en-usdaxxuserelationshipp-functiondaxx

Best, 

Paul

[Greg_Deckler · Accepted solution]

Correct, the second relationship is inactive. There can only be one active filter path between tables. However, you can use USERELATIONSHIP in a column or measure to specify the relationship that you want to use in a calculation.