Sprint Page Filter by Key

Questions & Answers
1

Hi,

I’m trying to build a filter on the Sprint dimension that would be in Page.
I would want the filter to give me only Sprint that have a higher key then 90 ([Sprint].CurrentHierarchyMember.Key>90)

I’m pretty sure I would need an aggregate or a Case When, but I don’t know how to set them up.

Could someone help me please?

Thanks,
Marilou

2

Hi @Marilou,

I recommend using the Aggregate() function to group the Sprint dimension “Sprint” level members and the Filter() function to retrieve desired members. See the suggested formula below:

Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Key > 90
  )
)

See the eazyBI documentation page for more details on the suggested functions - MDX function reference.

Best,
Roberts // support@eazybi.com