my problem is that “sprint issues completed” calculated member takes into account “sprint issues added” as well and not only “sprint issues committed”
solution by Zane Baranovska
to calculate the original estimate for issues which were committed and completed in as sprint
Sum(
– set of issues committed AND completed in a sprint
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
– filter conditions for issues
[Measures].[Sprint issues committed] > 0
AND [Measures].[Sprint issues completed] > 0
),
– sum up original estimate
([Measures].[Original estimated hours],
[Sprint].DefaultMember)
)