Issue by specifiek Epic

Hi ,

I am trying to create an EazyBI report where I show a list of Issues by all Epics with the word “Q3” in them. Is this possible? I have tried various Aggregate and Filter combinations but I usually end up with an error message. Any suggestions on the right calculated formula?

Many thanks!

Hi @lobke-stembert

Welcome to eazyBI community!

I recommend to create a calculated member in Epic Link dimension with the formula below

Aggregate(
  Filter(
    [Epic Link].[Epic].Members,
    [Epic Link].CurrentMember.Name MATCHES '.*Q3.*'
  )
)

The result might look similar to the screenshot below

Best wishes,

Elita from support@eazybi.com

1 Like