OK. Figured this out. This is due to how eazyBI handles sprints used in multiple boards. How can I see the board Name for value ‘Multiple boards’? - Questions & Answers - eazyBI Community
So I have to create calculated members to find all sprints with the sprint name.
This is the code I’m currently using:
Aggregate(
Order(
Filter(
[Sprint].[Sprint].Members,
Left([Sprint].CurrentMember.Name, 6) = “MDM PI” AND
[Sprint].CurrentHierarchyMember.GetBoolean(‘Closed’) AND
DateBetween(
[Sprint].CurrentMember.get(‘End date’),
‘12 months ago’,
‘Now’)
),
[Sprint].CurrentMember.GetDate(‘Start date’),
BASC
)
)
I tried to make this work so that it would take the five latest closed sprints based on sprint closing date but could not get it work, but this is OK for now.
But this also brings out an issue with using some of the standard measures like Running story points velocity of 5 closed sprints which does not work as it assumes that the sprints are in one board.
Is there a way to create a calculated measure that would utilise the calculated members to achieve the same result?