Zip codes in PowerPivot

[Misca]

I'm a PowerPivot newbie and I have a feeling this should be really easy but I still can't figure this out in PowerPivot:

I have a table with shipments data. Each shipment has two zip codes, one for origin and one for destination. I also have another table for zip codes with names, terminals etc.

My problem is I can't figure out how could I use just one zip code table for both origin and destination and how can I separate the origin and destination relations from one another?

 

[scottsen]

PowerPivot will allow you to create 2 relationships between the 2 tables... but only 1 can be "active" at a time. You will have to use the function USERELATIONSHIP to "reactivate".

OriginMeasure :=CALCULATE([SomeMeasure], USERELATIONSHIP(Facts[OriginZip], Zip[Zipcode]))
DestMeasure :=CALCULATE([SomeMeasure], USERELATIONSHIP(Facts[DestZip], Zip[Zipcode]))

 

[Misca]

Thanks!

That was just what I was looking for!