topic Running Total Line Chart with Filters in Desktop

Running Total Line Chart with Filters

rosscortb — Tue, 23 Oct 2018 10:46:05 GMT

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

Re: Running Total Line Chart with Filters

Stachu — Tue, 23 Oct 2018 11:01:04 GMT

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

Re: Running Total Line Chart with Filters

rosscortb — Tue, 23 Oct 2018 11:12:14 GMT

Hello,

Something like this.

Re: Running Total Line Chart with Filters

Anonymous — Tue, 23 Oct 2018 11:21:00 GMT

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]))

Re: Running Total Line Chart with Filters

rosscortb — Tue, 23 Oct 2018 11:31:45 GMT

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