DAX relationship issue - (Power Pivot- Excel)

Can any one explain why the pivot table in the attached is returning every NUTS _3 value rather than the one matched to the customers postcode in pc_uk_NUTS-2013 data model?

For example for the customer 80:20 Procurement Services Ltd, post code AB11 5BS, only NUTS value UKM50 should be displayed.

Instead every available nuts 3 value is displayed?

Regards
Mike
NUTS-postcodes.xlsx
mikes6058Asked:
Who is Participating?
 
clockwatcherCommented:
You haven't selected a value expression in your pivot.   As it is right now, Excel isn't doing any type of intersection between your two tables.  If you drag a column from your Customer List table as a value, Excel will give you the intersection that you're expecting to see.
FinishPivot.PNG
0
 
tomfarrarCommented:
0
 
mikes6058Author Commented:
Thanks clocky
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.