Calculation of runtotal filtering

[erhan_79]

Hi there ;

first of all have a nice work to everyboy

i need you kind support about a runtotal quantity filtering based on day.

i have a amount table based on days , i am calculating runtotal of amount based on days also , for sample table i have 3 month's daily amounts , days are starting from 01.07.2020 to 31.09.2020 , everyday has amount on the table.As you wil see from my sample that am adding it's link below also , i created a graphic to see runtotal of amounts .When the graphic is starting from 1 july everything is ok but when i want to start graphic from 01.08.2020 ( you can see the example page2 sheet on the report also ) , system calculating runtotal all july too.Infact when i filter the date i want system to start to calculate my first choosed date on the fılter , for the attached example 01.08.2020 's amount is 1500 , so i would like to see that on Page2 graphic will start to calculate 1500 and will calculate runtotal after 01.08.2020

sample pbix file  : https://drive.google.com/file/d/105-RiW_Tgn7OtbtqzOzNhNJnM90JQBUf/view?usp=sharing

source file :          https://drive.google.com/file/d/1k5JbHkujU-0xsw03TrcCfTJs5Fmow266/view?usp=sharing

i hope it is celar ,if you need to ask something s i will be here thanks in advance for your kind suppıorts 

[mahoneypat · Accepted solution]

Please try this expression instead

Toplam Runtotal TL ?
VAR minthisvisual ?
CALCULATE ( MIN ( Dimdate[Date] ), ALLSELECTED ( Dimdate ) )
Return
CALCULATE (
SUM ( Sheet1[Amount] ),
FILTER ( ALL ( Dimdate ), Dimdate[Date] <- MAXX ( Sheet1, Sheet1[File Date] ), ),
Dimdate[Date] > minthisvisual
)

If this works for you, mark it as the solution. Praise is also appreciated. Please let me know if you don't.

Best regards

Pat

[erhan_79]

@mahoneypat

thank you very much ! working perfect