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

[unknown_anony]

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

Am i missing any logic here?

Any suggestion are welcome

[rubayatyasmin · Accepted solution]

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.

[Ritaf1983]

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