Calculate sum of 2 measures over a time period for each month

[Anonymous]

Hello I have a rather simple question to ask but it is not giving me the result I want to have. 

I have 2 measures both being calculated over the same time period (month-year) where Month-year is a column.

The first measure is open tasks and the second measure in closed tasks. 

I want to have another measure/column called backlog such that i want to have the sum of (closed tasks-open tasks) for each month as i need to show it as a line in Line and clustered column chart.

I have been trying to find a way to implement this but SUM and SUMX function both are not working with measures. 

Does anyone have  way to calculate the SUM (closed tasks-open tasks) over Month-year? 

[AlB · Accepted solution]

@charu1313

You mean you want the accumulated difference? Treat

Measure =
CALCULATE (
    [closed tasks] - [open tasks],
    FILTER (
        ALL ( Date[Month-Year] ),
        Date[Month-Year] <= MAX ( Date[Month-Year] )
    )
)

Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.

Contact me privately for assistance with any large-scale BI needs, tutoring, etc.

Bless you

[Anonymous]

@AlB Thank you so much.

Works like a charm 🙂

[AlB]

Hi @Anonymous 

I'm not sure I'm following. Can you not just do ?

Measure =

[closed tasks] - [open tasks]

Most likely I'm misunderstanding something

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Hi @AlB ,

This is exactly what i did but it not giving me the exact result I want.

As you can see from this graph, for October I am getting -2 and for November I am getting -1.

In my scenario I wan to get for November -3, that is, the sum of (closed tasks - open tasks).

Can you please provide me some direction on how to work to get it?

Thank you.