Forum Discussion
Sum X for total excluding Month
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.
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.
1 Reply
- SamWiseOwl
Super User
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.