One fact, two countries, one country dimension table

[RPYee]

I have one fact table related to shipments.  Each shipment has an origin_country_wnbr and a dest_country_wnbr.  We have one country dimension table.  We are often trying to create shipment records where we specify the origin and destination pairs.  How can I bring in the one country dimension table yet create a relationship to both the origin_country_wnbr and the dest_country_wnbr?

[ajohnso2 · Accepted solution]

Duplicate your country table (referenced) in power query. 

Now you can setup a new relationship to your newly created country table on destination_country

[ryan_mayu]

pls provide some sample data and expected output.

[PabloVallejo12]

You can try to use a ID country?

[RPYee]

Not understanding your suggestion.

[PabloVallejo12]

If you have the county in both tables, add an unique ID for each country and use it for the relationship

[RPYee]

The country dim table has a primary_key assigned to each country code.  Could I simply duplicate that key as a new column, then use it to create one of the two relationships needed to the fact table?  I apologize for my lack of experience here.  I am a very new PBI user and certainly appreciate your patience!