Calculate Committed Stories completed in a Sprint

Questions & Answers
1

I am trying to see of there is a way to calculate how many of the committed stories were completed in a sprint

I tried the below code but getting an error

(
[Measures].[Sprint issues at closing],
[Measures].[Sprint issues committed]
)

2

Hi Brian,

You could try to create the calculated measure with the code below:
​
NonZero(Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Sprint issues committed] > 0
AND
[Measures].[Sprint issues at closing] > 0
)
))

The formula returns the count of all issues that have been committed to and closed in a sprint.
But please be advised that the formula goes through all of the issues, and the set can get quite large.

Best,
Robert / support@eazyBI.