Hi All,
I am trying to get the velocity for a roll up of sprints. You can see that when I expand the sprints it shows the velocity each sprint but when I collapse the sprints it doesn’t show the velocity.
I am using this for Velocity:
CASE
WHEN
[Sprint].CurrentHierarchyMember.Level.Name = ‘Sprint’ AND
[Sprint].CurrentHierarchyMember.GetBoolean(‘Closed’)
THEN
AVG(
Tail(
Filter(
– filter last 5 previous sprints in a board starting from current sprint
[Sprint].CurrentHierarchyMember.FirstSibling:
[Sprint].CurrentHierarchyMember,
[Sprint].CurrentHierarchyMember.GetBoolean(‘Closed’)
),
– set the count of last closed sprints for running velocity
5 ) ,
[Measures].[Completed Story Points with out Bugs]
)
END
How can I modify this measure to show a roll up?
Thanks!