Total sales change based on the selection

[THENNA_41]

How to change total sales based on the Month  selection ? 

IF i select any particular month totalsales Value also need to change .

Sample Data :

\

If i select any particular Month i want output looks like below 

Month           Sales            TotalSales

1-10-2021      226               507

1-11-2021      281               507

I have attached Smaple File  : Sample File  

[FreemanZ · Accepted solution]

hi @THENNA_41 

change ALL to ALLSELECTED like:

TotalSales = CALCULATE(SUM('Table'[Sales Volumn]),ALLSELECTED('Table'))

it worked like: