Powerpivot Join issue with duplicate values(Many 2 Many)

[konquistador]

Hi, please find my situation below. I have two tables called Table1 and Table2 as below.

Table1: Zipcd1, Dim1, Dim2, Measure1
Table2: Zipcd, CountyName

In my final result, i just want to show CountyName for all the zip codes in the Table1.Zipcd1. This was a very simple thing in MS Access, if we join those tables on Table1.ZipCd1=Table2.Zipcd. But since powerpivot does not allow many 2 many relationships, when i try to join on Zip codes its throwing error below:
"Relationship cannot be created because each column contains duplicate values."

I have done below:
Split the Table2 into 2 tables:
Table2.1: ZipCd(Distinct values)
Table2.2: CountyName.

Now i am able to make the below joins
Table1.Zipcd1 = Table2.1.ZipCd
and
Table2.1.ZipCd = Table2.ZipCd
but still i cannot seem to get to the county name values, I am still getting errors when adding Table2.CountyName to my pivot table.

Am i missing something? I read the many2many articles by marco and alberto but are complex to understand for a novice excel user.Also they mostly talk about calculated measures, whereas in my case i just need to handle dimensions.
Please Advise.


Thanks,
Kon