Epics of a Project lead

Questions & Answers
1

Hello,

Im trying to make a calculated member of the Sprint Dimension.
Where returns all the Sprints associated to projects of a specific Project Lead.

What I tried:

Aggregate(
Generate(
NonEmptyCrossJoin(
Filter(
[Project].AllMembers,
[Project].CurrentMember.GetString(‘Project lead’) = ‘Catalina Garcia’
),
[Sprint].AllMembers
),
[Sprint].CurrentMember
)
)

But Its not working as expected!

2

Hi @jcaristy,

You are almost there. Please update the formula to filter the Project dimension members in the “Project” level, because only the “Project” level members have the property ‘Project lead’.

Also, do the same for the Sprint dimension to use the “Sprint” level. The formula could look like this:

Aggregate(
  Generate(
    NonEmptyCrossJoin(
      Filter(
        [Project].[Project].Members,
        [Project].CurrentMember.GetString('Project lead') = 'Catalina Garcia'
      ),
    [Sprint].[Sprint].Members
    ),
  [Sprint].CurrentMember
  )
)

Kind regards,
Roberts // eazyBI support