Total sales change based on the selection

Anonymous — Thu, 16 Feb 2023 08:44:40 GMT

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

Re: Total sales change based on the selection

FreemanZ — Thu, 16 Feb 2023 09:06:14 GMT

hi Anonymous

change ALL to ALLSELECTED like:

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

it worked like: