asked on
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
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
Microsoft ExcelMicrosoft SQL ServerMicrosoft AccessMicrosoft Office
Last Comment
mikes6058
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks clocky
https://msdn.microsoft.com/en-us/library/gg492168.aspx