i’m struggeling with the simple task to devide “Story Points due” within the Project Dimension through the “avarage running velocity for 5 closed sprints”.
What i have done so far:
I created a new calculated Measure to get the Running Velocity per Board:
[Measures].[Sprint closed?]=“Yes” AND
NOT IsEmpty([Sprint].CurrentMember.get(‘Complete date’)) AND
[Measures].[Sprint Story Points completed] > 0
[Measures].[Sprint start date],
[Measures].[Sprint Story Points completed]
Then i realized, that Story Points due are most likely in our Backlog and so not assigned on any board (Board is a hierarchy member of Sprints, so unresolved Storys are assigned to (no board)).
So what we would need is basicly what i said.
Project on Rows and [Measures].[Story Points due] / Velocity of the last 5 Sprints within this Project (Or any Board within the Project)
We want to know how many Sprints could be filled with the Story Points in our Backlog.
Does anybody has some help?
Thank you in advance,