Allocating specific amount based on sales share

[cdawidow]

Hi guys, I am having trouble with my dax calculation to effectivelly allocate rebate dollars based on share of net spend per product catagory (MERGED) 

I have calculated each custoemrs sales share correctly using the formula: Calculate(total sales) / calculate(total sales),all(table1,customername)

But I now want to take that share and multiply the total rebate amount per product segment  for each customer to allocate rebate amount for each customer but I am not getting correct answers.  Please see below screenshot to see my calculations. 

For example, the highlighted customer should have $33,478 total rebate amount and not $2921 as their sales share was 50.33%.  Any help would be appreciated

[amitchandak]

@cdawidow , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.