How to calculate committed story points removed

Questions & Answers
1

Hello everyone. My first post here and I’m stuck in EazyBI calculation. Please be gentle.

I’m trying to calculate the number of committed story points removed from a sprint. I have number of story points removed.

However, I want the number of removed stories from committed stories.

So, my colleague and I tried this logic:

CASE WHEN
[Measures].[Sprint Story Points committed] > 0
THEN
[Measures].[Sprint Story Points removed]
END

It comes back with 0. We know that isn’t correct.

Any assistance is greatly appreciated.

2

Hi @windpooh2,
Here in this eazyBI demo report “Sprint issue balance” you can find a similar measure “Sprint issues completed of committed”: Sprint issue balance - Issues - Jira Demo - eazyBI

You can adjust the measure so it would work with committed and removed story points.

best,
Gerda // support@eazyBI.com

3

Thank you so much for your reply. That’s the issue. We have the issues number. There is a planned_removed calculation for issues, but not story points. We are trying to get the story points of committed that were removed. Every calculation we have tried does not provide the correct results. So, we tried to get a listing of the number of committed story points and then of that list provide the number of those removed. Doesn’t return the results only 0

4

@windpooh2, did you adjust your formula accordingly to my suggestion?
Please share the current formula you are using now.

5

This is what I have based on the committed and delivered. I know it is something simple that I’m missing. I truly appreciate your assistance on this.

CASE WHEN count(VisibleRowsSet()) <=10 THEN – this line will enable the meausre for max 2 board selection only to improve the performance
CASE WHEN
[Sprint].Currentmember.Level.name = “Sprint”
THEN
NonZero(SUM(
Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
CoalesceEmpty([Issue].CurrentMember.Get(“Sprint IDs”),
CoalesceEmpty([Measures].[Issue Sprint], “”)
) MATCHES “."|| Cast([Sprint].CurrentMember.Key as string) ||".”
),
CASE WHEN
[Measures].[Sprint Story Points committed] > 0
THEN
CoalesceEmpty(
[Measures].[Sprint Story Points removed])
END
))
END
END

6

This was our original logic

CoalesceEmpty(CASE WHEN
[Sprint].Currentmember.Level.name = “Sprint”
THEN
NonZero(SUM(
Filter(
Descendants([Issue].Currentmember, [Sprint].[Sprint]),
[Sprint].CurrentMember.Name = [Measures].[Issue Sprint]
),
CASE WHEN
[Measures].[Sprint Story Points committed] > 0
THEN
[Measures].[Sprint Story Points removed]
END
))
END, 0)