Target vs Actual

[Anonymous]

Hi All, 

I have 2 tables - 1 for Actual Sales from SAP BW, OTher is Targets in an Excel. 

We have targets by Region Level by SKU. 

I made a relationship btw 2 tables with a calc.column Region&SKU. 

My problem is: If there is no target for a specific region and SKU, I cannot see the actual and grand total does not become true for that region in actual sales. 

Please help me correct that. 

Regards.

[MattAllington · Accepted solution]

Never join two data tables together directly. Instead join to a common lookup table, where the lookup table has a superset of every value in the columns in the joins. 

https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/