Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

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:

darko_ivanovic_0-1686040165284.png

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:

 

darko_ivanovic_1-1686040392135.png

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: 

darko_ivanovic_2-1686040746588.png

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 ? 

0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.