CODEWITHSUNDEEP
sqlexcelpowerpivot
BoNDoK
BoNDoK

Reputation: 145

powerpivot inner join

I have one table:

Person Name Country code
Andrew      1
Philip      2
John        1
Daniel      2

and a lookup table:

Country code    Country name
1               USA
2               UK

I added them to powerpivot, created a relationship between the country code fields, then I created a pivot table. I expect to get the following: 

Person Name Country code
Andrew      USA
Philip      UK
John        USA
Daniel      UK

But what I actually get is:

Person Name Country code
Andrew      USA
Andrew      UK
Philip      USA
Philip      UK
John        USA
John        UK
Daniel      USA
Daniel      UK

Upvotes: 0

Views: 1016

Answers (1)

Jacob
Jacob

Reputation: 3557

Couple of options:

  1. Add a column to your main table that uses a formula to pull in the Country Name from your LookUp Table e.g. =RELATED(LookUpTable[Country Name])

  2. If you drag in any measure that references the main table you will get your desired result e.g. =COUNTROWS('MainTable') You then hide the results column if you had to.

Upvotes: 1

Related Questions