Sprint Story Points committed completion %

Hi,

I want to use this predefined measure. But how will i take the sprint story points committed completion for the latest closed sprint. I tried using the following to filter out the latest sprint, however its resulting blank:

SUM(
Generate(
Descendants([Sprint].Currentmember, [Sprint].[Board]),
Tail(
Filter(
[Sprint].CurrentMember.Children,
[Sprint].CurrentMember.GetBoolean(“Closed”)), 1)
– 5 last closed sprints within each board

)

Hi @anoopkrkumar ,
You can create a calculated member in the Sprint dimension using this formula for member “Last 5 closed sprints from all boards” from the eazyBI demo account:

Aggregate(
  Generate(
  -- get all boards
    [Sprint].[Board].Members,
    -- access all children - sprints from the board and get the last 5 closed
    Tail(
      Filter(
      [Sprint].CurrentMember.Children,
      [Sprint].CurrentMember.GetBoolean("Closed")),
      5)
  )
)

best,
Gerda // support@eazybi.com