How to create a filter to get the latest 10 sprints from a given project?

[Marino]

My company has many different projects and too many sprints.
I need to create a graph that can show only the last 10 sprints for my project.

I have tried this:

Aggregate({
  Tail(Order(
    Filter([Sprint].[Sprint].Members,
      NOT isEmpty([Measures].[Sprint Start Date])),
    [Sprint].CurrentMember.get('Start date'), BASC
  ), 10)
})

But returns the last 10 sprints for ALL projects.

How do I do that?

[Fabian Lim]

Hi @Marino

You can find an example here: https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099

Regards