Hi,
We have the following set up:
The calculated members for sprints have the following formula:
SpyderPI3 for example:
Aggregate(
Filter(
[Sprint].[Sprint].Members,
[Sprint].CurrentHierarchyMember.Name MATCHES “.Spyder.”
AND [Sprint].CurrentHierarchyMember.Name MATCHES “.PI03.”
)
)
The formulas for
Story Points Committed:
( [Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was in a sprint at a sprint start time
[Issue Sprint Status Change].[Future => Active],
[Time].CurrentHierarchy.Levels(‘Day’).DateMember(
[Sprint].CurrentMember.get(‘Start date’)
)
)
Story Points completed:
(
[Measures].[Sprint Story Points at closing],
[Transition Status.Category].[Done]
)
My question is, why is the total not calculated for “Story Points committed”, but for every other measure it is?
Can I change that?
Thank you!