Sum X for total excluding Month

[JPSingh]

I am trying to get to a formula which will allow me to * each row value by the grand total %  for that region. 

e.g. In my first table I have the data for my upsell and then the % which is basically Upsell / Target 

In this table you can see the total upsell % without the the month breakdown

I need a formula which will basically take each row value above and * by the upsell % below 

e.g. for AMER it should basically look at each row value above and multiply by the value in second table 

Nov = 22,500 * 103% 

Dec = 54,000 * 103%
The SUMX formula I am trying doesn't seem to work.  

[SamWiseOwl · Accepted solution]

Hi @JPSingh 

Multi by total =

var totalper = Calculate( [upsell %], allselected(table[region]), allselected(table[month field]))

return [upsell $] * totalper

Calculate can remove filters, here we use ALLSelected to remove the row filters in the visual.

Remove the fitler from the month column and the region column.