Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Total sales change based on the selection

How to change total sales based on the Month  selection ? 

 

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

 

Sample Data :

 

total sales Pic.png\

 

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  

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @Anonymous 

change ALL to ALLSELECTED like:

TotalSales = CALCULATE(SUM('Table'[Sales Volumn]),ALLSELECTED('Table'))
 
it worked like:
FreemanZ_0-1676538365573.png

 

View solution in original post

1 REPLY 1
FreemanZ
Super User
Super User

hi @Anonymous 

change ALL to ALLSELECTED like:

TotalSales = CALCULATE(SUM('Table'[Sales Volumn]),ALLSELECTED('Table'))
 
it worked like:
FreemanZ_0-1676538365573.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.