How to divide values using total of same column - filtered

[tblackwell311]

Hello,

I need to create a measure that returns the "% of total" in green, not the "% of total in red".

Region	Item	Price	Quantity	Dollars		% of Total	% of Total
Kansas City	Hamburger	$1.00	4	$4.00		20.0%	13.3%
Kansas City	Cheeseburger	$1.50	4	$6.00		30.0%	20.0%
Kansas City	Double Cheeseburger	$2.00	5	$10.00		50.0%	33.3%
St. Louis	Hamburger	$1.00	1	$1.00		10.0%	3.3%
St. Louis	Cheeseburger	$1.50	2	$3.00		30.0%	10.0%
St. Louis	Double Cheeseburger	$2.00	3	$6.00		60.0%	20.0%

My formulas

Sales = sum(Table1[Dollars])

Total Sales = CALCULATE(sum(Table1[Dollars]),ALL(Table1))

% of Total = CALCULATE(DIVIDE([Sales],[Total Sales]))

My result is the % of total in red.

What I want is the % of total in green, which is the filtered % of total.

Please note that I am using a slicer.

[HotChilli]

If you rewrite the Total Sales measure as

Total Region Sales = CALCULATE(SUM(Table1[Dollars]), ALLEXCEPT(Table1, Table1[Region]))

and use that as the denominator, it should get your result.

Format it as a %.