Many to Many Pivot Relationship Issues

[willstein818]

Hi Everyone,

So I'm currently making a dashboard that shows sales achievements per Customer Name compared to their targets.
In the 'Raw' table, I have created the Baseline & Actual for each Customer, while the 'Sales Target' table shows the Monthly Target per Customer, I also have created bridge tables to make a Many to Many pivot table relationships. (Power Pivot relationship usage)

The Steps that I will take are as follows:
1. Make a 'BaselineTotal' (Sum of all baseline sales in each 'Account')
2. use Divide measures ('Sum of Baseline' / 'Baseline Total') to get Customer Name Percentage (Sales Percentage contribution of each customers inside the account)
3. Use the Customer Name Percentage*Sum of Target Qty to get Specified Sales Target for each Customer Name.
4. Compare the target to the 'Actual' and get total achievement.

I'm stuck at the first step, in which the 'BaselineTotal' didn't show the correct numbers for each 'Account'. Moreover, the formula has created an 'error' in which Customer Name appears at the wrong 'Account', even though i have filtered it using slicers (All slicers are from 'Unique' Table)

Is there any solution to make this dashboard happen? What did I do wrong at the Pivot Table Relationships? Thanks a lot for your help.

Regards,
William