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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.