Story point change within a sprint

Hello, we are looking to do a report that shows issues which, at the start of the sprint, had a story point value of null but then were given story points during the sprint.

I know that you can report on a change of story points within a sprint, but we want to identify the issues that were there and started with a story point value of null/empty.

In this case, you would like to check several activities for each issue - if it was committed in a sprint and if there was no story points or 0 story points at the time of commitment. Then you also should check if there were any points added during the sprint as well.

Here is an example formula for this:

CASE WHEN
    [Sprint].Currentmember.Level.name = "Sprint"
THEN
  NonZero(SUM(
   -- filters possible issue set in Sprint using properties only
    Filter(
      Descendants([Issue].Currentmember, [Issue].[Issue]),
      DateCompare(
        [Issue].CurrentHierarchyMember.Get('Created at'),
        [Sprint].CurrentMember.Get('End date')) <= 0
      AND
      (isEmpty( [Issue].CurrentHierarchyMember.Get('Resolved at'))
      or 
      DateCompare(
        [Issue].CurrentHierarchyMember.Get('Resolved at'),
        [Sprint].CurrentMember.Get('Start date')) > 0)
      ),
      CASE WHEN
      -- filters by activity in sprint: committed with no Story Points that were added later.
       [Measures].[Sprint issues committed] > 0
       AND
       CoalesceEmpty([Measures].[Sprint Story Points committed],0) = 0
       AND
       [Measures].[Sprint Story Points change] > 0
      THEN
       [Measures].[Sprint issues committed]
      END
  ))
END

Daina / support@eazybi.com