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
unknown_anony
Helper II
Helper II

The Running Total is not getting filter from the values in same table

Hello,
I have a measure calculating the Rolling sum of last three months and it is giving me the correct result. But when i am trying to filter the sum using a column from the same table from where the measure is calculated the result is not filtering. Below screen shot will help you understand better

unknown_anony_3-1689832228265.png

 

unknown_anony_2-1689832194429.png

 

 

Am i missing any logic here?

Any suggestion are welcome

1 ACCEPTED SOLUTION
rubayatyasmin
Super User
Super User

Check if your interactions are on. See edit interaction. if that is not the issue then

 

maybe because of the context in which the measure is being calculated. In Power BI, the "CALCULATE" function changes the context in which data is analyzed, and it sounds like you're using it in your measure.

 

suggestion add filter to your calculation. then field you are using in your slicer, filter it. for example

 

ALL(Table[Date]), VALUES(Table[slicer clumn name])

 

you need to adjust your measure with correct names and syntax.

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


View solution in original post

2 REPLIES 2
rubayatyasmin
Super User
Super User

Check if your interactions are on. See edit interaction. if that is not the issue then

 

maybe because of the context in which the measure is being calculated. In Power BI, the "CALCULATE" function changes the context in which data is analyzed, and it sounds like you're using it in your measure.

 

suggestion add filter to your calculation. then field you are using in your slicer, filter it. for example

 

ALL(Table[Date]), VALUES(Table[slicer clumn name])

 

you need to adjust your measure with correct names and syntax.

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Ritaf1983
Super User
Super User

Hi @unknown_anony 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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.

Top Solution Authors