Number of Sprints for issues to get completed

Questions & Answers
6

Hi,

Very recently I sent an email to the eazyBI team and, for something related to this I got help with this formula:

case when
[Issue].Currentmember.Level.Name = “Issue”
Then
Generate(
Filter(
[Sprint].[Sprint].Members,
[Sprint].CurrentMember.Name <> “(no sprint)” and
[Measures].[Transitions to] > 0
),
[Sprint].CurrentMember.Name, ", "
)
End

This shows also sprints in which an issue has been, and the following counts them:

case when
[Issue].Currentmember.Level.Name = “Issue”
Then
Count(
Filter(
[Sprint].[Sprint].Members,
[Sprint].CurrentMember.Name <> “(no sprint)” and
[Measures].[Transitions to] > 0
))
End

This is close I could get to what I needed, and it’s very useful.