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
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