Sales and Targets tables are not linking to calculate SvT

[RD_PowerBI24]

Hi, 

I am trying to do an SvT measure using Sales and Targets coming from 2 tables with field with same item values. I want the fields in the Sales table to manipulate and dynamically change based on selection of territory, month and product. 

Here is the relationship between 2 tables. At present, the Territory to CEM Territory is the active relationship.

The table appears as below when bringing in the All_Invoice Date (Which has date hierarchy), Sum of Target, CEM Territory, Master_Prod_Name & All Sales:

The all sales is correctly appearing, however, the targets are allow aggregated instead of showing the actual targets from the target table. Please can you let me know what I need to correct or setup for the sales and target values to respond to CEM Territory, Master_Prod_Name & All_Invoice Date.

Thank you

[Anonymous]

Hi,@RD_PowerBI24 I am glad to help you.
Has your problem been solved?
If you find a suitable solution, please share it with everyone as it will help more users solve similar problems!

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattAllington]

Sorry to be the bearer of bad news, but this is completely the wrong approach. You should start again. I suggest you start here. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/   Invest time understanding and reshaping your data, then the reporting will be relatively easy