# How to calculate committed story points removed

**URL:** <https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138>\
**Category:** Questions & Answers\
**Created:** [March 22, 2022, 9:40pm UTC](https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138 "2022-03-22T21:40:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![windpooh2](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/a3d4f5/32.png) [@windpooh2](https://community.eazybi.com/u/windpooh2)\
**Post date:** [March 22, 2022, 9:40pm UTC](https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138/1 "2022-03-22T21:40:07Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [March 28, 2022, 10:07am UTC](https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138/2 "2022-03-28T10:07:55Z")

</div>

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](https://eazybi.com/accounts/1000/cubes/Issues/reports/243468-sprint-issue-balance)

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

best,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![windpooh2](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/a3d4f5/32.png) [@windpooh2](https://community.eazybi.com/u/windpooh2)\
**Post date:** [March 28, 2022, 4:34pm UTC](https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138/3 "2022-03-28T16:34:24Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [March 29, 2022, 8:29am UTC](https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138/4 "2022-03-29T08:29:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![windpooh2](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/a3d4f5/32.png) [@windpooh2](https://community.eazybi.com/u/windpooh2)\
**Post date:** [March 29, 2022, 7:08pm UTC](https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138/5 "2022-03-29T19:08:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![windpooh2](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/a3d4f5/32.png) [@windpooh2](https://community.eazybi.com/u/windpooh2)\
**Post date:** [March 29, 2022, 7:15pm UTC](https://community.eazybi.com/t/how-to-calculate-committed-story-points-removed/9138/6 "2022-03-29T19:15:23Z")

</div>

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)