Finding Resolved Story Points of Stories assigned to a sprint at a specific date

Questions & Answers
, ,
1

I am looking to create a measure that shows me the story points resolved in the sprint they were assigned to on a specific date.

Example: April 10th showed 30 SP assigned to our Sprint 1 which had the dates of April 25th- May 8th. I want to know of those 30 SP which were actually completed during that Sprint 1.

Currently I am using the below to show all of those at start of PI in status Closed. However,

  1. It’s showing the issues that are closed, not what was closed during that sprint.
  2. I want to see all that were Resolved as Done in the sprint. Closed includes resolutions I don’t want to see.

NonZero

(

(
[Measures].[Story Points Committed at Start of PI],
[Status].[closed]
)

)

Screenshot 2025-07-06 at 19-05-03 25.2 Percent Complete Projection (Sprint by Sprint in PI) - Issues - US E-7A SW - eazyBI
Screenshot 2025-07-06 at 19-05-03 25.2 Percent Complete Projection (Sprint by Sprint in PI) - Issues - US E-7A SW - eazyBI857×302 16.7 KB

Cumulative columns are there just to show when a certain amount of story points are meant to be complete based on the PI Plan and the amount that was closed so far.

I want to focus on Story Points Committed at Start of PI. This is correct. I used a specific date to tell me what story points where in those sprints. It does show everything and not just unresolved or resolved as done. I would like to get the count of story points in that sprint on that date that were Unresolved.This is what I am using now…
(
[Measures].[Story Points history],
[Time].[Day].[Apr 10 2025]
)

Now I want to look at Story Points Completed of PI Plan
It just shows me everything that is in a closed state regardless if it was within the sprint it was assigned to at the specific date Apr 10th. I also only want to see issues resolved as done during the sprint it was assigned to on Apr 10th. I put my current measure for this column above the table.

Additionally, I am using the Sprint Dimension in the Rows.

Any help would be awesome!

2

Hi @Kayris06,

eazyBI has to consider the respective issues individually, to determine their state regarding the Sprint on a particular date and at Sprint completion. I recommend the following calculated measure formula:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Issue].CurrentHierarchyMember.GetString('Sprint ID') = Cast([Sprint].CurrentHierarchyMember.Key as string)
  ),
  CASE WHEN 
    [Measures].[Issues history] > 0
  THEN
    ([Measures].[Sprint Story Points completed],[Time].CurrentHierarchy.DefaultMember)
  END
)

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures.

Best,
Roberts // support@eazybi.com

4

After using the measure, I see that it includes all story points completed in the sprint. Not the story points completed in the sprint that were originally put into the sprints at a certain date.

For instance,

On Day 1 of sprint 1 we locked in everything that was in each sprint, and considered that the original plan.
If we look at Sprint 2, on said date it has 20 Story Points in it. I want to know how many of those original 20 were closed by the end of Sprint 2. I don’t want to see anything that was added afterwards and all closed at the end of the sprint.
Currently when I try this measure, it includes issues that were added into the sprint after the start of the sprint.

Does that help make it more specific?