Problem regarding cumulative budget using slicer

[Anonymous]

I am working on creating a PnL report where I’m showing PnL against budget per month in a bar chart and cumulative PnL against budget in another line chart (separated lines). User has two options by filtering by year and month.

By filtering by month (for example, January - June) I want the result to show for filtered months. But I want the budget graph to show for all 12 months regardless of the month filter. I managed to fix this with in the bar graph, but I’m having problems creating the correct measure showing cumulative budget that exclude the month filter.

Working fine i barchart:

Budget amount = CALCULATE([Budget amount];ALL(Dim_Time[Month]))

Issue in linechart:

Budget accumulated = TOTALYTD(Fact_Budget[Budget amount]; Dim_Time[Date] ; ALL('Dim_Time'))

Hope someone can give me an example of measure showing accumulated numbers with filters. Now I have tried everything.

[MattAllington]

Most people would know how to fix this in Excel. In fact if you switch the line chart to a matrix, you would probably immediately know what to do. Just wrap the formula in an if statement.  Check if here are sales this year, and only show the cumulative  total if there are (or what ever it is you are trying to do). It can be a bit more challenging if you data is loaded daily. In that case you need a different approach. 

[Anonymous · Accepted solution]

Thank you for your response, but it doesn't cuite answer my question.

Luckily i managed to work around the issue by adding some parameters in the query.

Issue is solved.