Running Total unabled while clicking on specific month

[Anonymous]

Hello everyone! 

I'm facing a huge trouble while writing a DAX code for my PBI Report.

As you can see in the images when there's no month filter applied it computes correctly the Amount until May. However, whenever I click on any month in the report, it computes the clicked month value, instead of the running total until that month.

For example, if I click on April, instead of computing the values of Jan + Feb + Mar + Apr, it shows only the value for April.

If any kind heart can help me with that I would be really greatful. 🙂

without applying month contextwhish to have running total until the selected month

[lbendlin · Accepted solution]

You forgot the FILTER(ALL()) part when you specify all the previous months.

[Anonymous · Accepted solution]

@lbendlin could u help me with the continuing answer? Tks and best regards!

[lbendlin · Accepted solution]

You forgot the FILTER(ALL()) part when you specify all the previous months.

[Anonymous]

Hi, Ibendlin! Thank you so much for the help! But, could you be more specific? How would you approach this problem? 

FILTER ( ALL ( DATA ) ) or FILTER ( ALL ( DATA) , DATA[MONTH] = 1 || DATA[MONTH] = 2 ....?

[Anonymous · Accepted solution]

@lbendlin could u help me with the continuing answer? Tks and best regards!

[lbendlin · Accepted solution]

here's the pseudo code:

var currentmonth = selectedvalue(month)

return calculate(your calculations, filter (all(dates),dates[month]<=currentmonth))

Note: you may need to add a year filter if you have data for more than one year.

[Anonymous]

now it's worked perfectly!

Many tks!!