Using Calculation with Slicer to use in Measure Calculation

[Anonymous]

I have the below table displayed in a report:

State	Discounted Sales	All Sales
MA	50	200
SC	100	500
NY	150	300

I want the below [Discounted % of Total] column to be created below:

State	Discounted Sales	All Sales	Discounted % of Total
MA	50	200	5%
SC	100	500	10%
NY	150	300	15%
Total	300	1000	30%

The issue is everytime I create a new measure and try to calculate the All Sales Total (1000) it automatically groups it by ['State'], so using first row as an example, it displays 25% (50/200) intead of 5% (50/1000). I've tried CALCULATE, SWITCH, FILTER etc and all with the same result. 

Also in my report I have a date slicer by year, quarter and month which pulls from another [Date] Column, so when I apply the slicer by Date, I want table to update. So for example, in the first row, if I filtered by 2021, and the total number of sales was 500 instead of 1000, [Discounted % of Total] would update to 10% (50/500)

I've been able to find the total sales figure by using the MAX aggregation on [All Sales] bu then the number doensn't respond to the slicer. 

Thanks in advance!

[ryan_mayu · Accepted solution]

@Anonymous 

pls try this

% of total = sum('Table'[Discounted Sales])/CALCULATE(sum('Table'[All Sales]),all('Table'))

pls see the attachment below

[johnt75]

Discounted % of total =
VAR currentValue =
    CALCULATE ( SUM ( 'Table'[Discounted Sales] ) )
VAR totalValue =
    CALCULATE ( SUM ( 'Table'[Discounted Sales] ), ALLSELECTED ( 'Table' ) )
RETURN
    DIVIDE ( currentValue, totalValue )