Show at Page Level only Project with Active Sprints

Hi,

Theres any way to Filter projects that have created sprints, and show them at Page Level ( Not in the Rows )?

I need to show at Page level, only the projects that have Created Sprints, Active Sprints , Closed Sprints.
I understand that Project and Sprints don’t have direct relation in the current model.

But can during the import create that type of relation ?
New Dimension for example.

Thanks

Hi Joaquim,

You could create a calculated member in Project dimension to Aggregate(…) all Projects that have any Sprint association except ‘(no sprint)’. The formula would be as follows

Aggregate(
  Generate(NonEmptyCrossJoin(
    Filter([Sprint].[Sprint].Members, 
      [Sprint].CurrentMember.Name <> '(no sprint)'),
    [Project].[Project].Members
  ), [Project].CurrentMember)
)

Lauma / support@eazybi.com

1 Like

Thats Perfect, exactly what i Required.

An aditional questions :slight_smile:

At Page Level It’s possible to have a second Calculated Member be filter by the current member of the First Calculated Member.

Eg:
At Page Level : Project ( Caculated member ) and Sprint ( Caculated member )

When a select a Project on the First Calculated Member, the second one only shows Sprint Related with that project ?

Joaquim,

Great to hear that the calculated member is working as expected!

For the additional question - no, for now eazyBI does not support value limitation in page filters based on selected values in other filters. Thank you for this idea, we will consider this for future development!

Lauma / support@eazybi.com