Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter not affecting calculation for Burndown

Im trying to create a burndown report for my company. 
Things got a little bit complicated but i managed somehow to achieve it. 

Now my problem is that filtering is not working. I try to explain:

This is my Change_history Table, here are changes logged of the field Story points (Total Time) and Remaining SP (remaining time).

As you can see here are only changes logged and I don't have a remaining time value for each day.

To get a Remaining value for each day I created a Datetable:

 

What I also have in this Table is to which Sprint and which Program Increment this day belongs. 

But the important thing is the Remaining SP column:

 

Remaining SP = 

CALCULATE (
        SUM(change_history_SP[newstring RMSP]) - SUM(change_history_SP[oldstring RMSP]),
            FILTER(
                change_history_SP,
            change_history_SP[created] <= EARLIER ( [Date] )
            )
)

 

With this calculated column I sum up the remaining SP values until each Date. This also functions as it should. 

To get an "ideal line" i created another calculated column with as following: 

 

ideal line = IF('Date'[RemainWorkDays] = BLANK(),BLANK(),'Date'[Story Points] - ('Date'[Story Points] / MAX('Date'[RemainWorkDays]) * (MAX('Date'[RemainWorkDays]) - 'Date'[RemainWorkDays]+1)))

 

This is also working. When i visualize this it looks like this: 

And this is fine, it does not look perfect but thats due to, not all issues having "Remaining SP" values.

My problem is now that for the " Remaining SP" line when i want to filter by "Team" 

it does not affect anything. Nothing changes. I was hoping by filtering "Team" it would only then use the rows where team is equal to selected filter value to use for calculation.

 

Any ideas ? 

No Replies