Running Total Line Chart with Filters

[rosscortb]

Hello 

Not even sure its possible but can anyone help me do a measure that can be used in a Line Graph that shows Month at the bottom and Totals on the side.

I want the monthly total for overtime.

I think the problem is I have page filters so it keeps changing it.

I tried something like - 

Month by Month = CALCULATE(SUM('DB Overtime Master'[Total],FILTER('Month','Month'[Month])))

Thanks
Ross

[Anonymous · Accepted solution]

Do you mean like this?

  

Your measure is the Value and your month is the Axis.

Alter your measure to this:

CALCULATE(SUM('DB Overtime Master'[Total],ALL('Month'[Month]))

[rosscortb]

Thank you. Sometimes its quite frustrasting as it can be a , or ( in the wrong place and throws whole thing out.

[Stachu]

I'm not clear what do you want to achieve
do you mean YTD calculation? can you share sample data?

[rosscortb]

Hello,

Something like this.