Get Completed Issues

Hello, everyone. Can you help me to structure a formula where I could see the sum of issues completed in a sprint before this sprint is completed?

I’d created this formula, but this is returning nothing to me:

CASE WHEN
[Sprint].Currentmember.Level.name = "Sprint"
THEN
  NonZero(SUM(
  Filter(
    Descendants([Issue].Currentmember, [Issue].[Issue]),
    [Sprint].CurrentMember.Name = [Measures].[Issue Sprint]      
  ),
  CASE WHEN
      [Measures].[Sprint issues committed] > 0 OR [Measures].[Sprint issues added] > 0
  THEN
      [Measures].[Sprint issues completed]
  END
  ))
END

I appreciate your help.

Cheers,
Marcelo

Hi, Marcelo,

The measure of Sprint Issues completed returns anything only for completed sprints, and referring to it in the formula is the reason why it stays empty.

For the active sprint, the standard measure of Issues resolved should be used instead.

Kindly,
Janis, eazyBI support

1 Like