This is the code I used:
Aggregate(
Filter(
[Epic link].[Epic].Members,
[Measures].[Issue resolution] = “unresolved”
)
)
I also tried:
Aggregate(
Filter(
[Epic link].[Epic].Members,
[Issue].CurrentHierarchyMember.get(‘Epic Status’) MATCHES ‘Analyzed’
)
)
I would like to see all Epics in GIVEN status, with all of the stories in ANY status.
If I filer for the status of the issues, it filters out also to resolved stories of the epic, not just the epic.
Where you should use the ID for the status Analyzed instead of 10001
To find the ID, you can create one new separate report with “Status” dimension in rows expanded and new calculated measure in columns (using this formula: [Status].Currenthierarchymember.Key
)
I don’t see any syntax mistakes in your approach.
In fact, I tried the same approach for my calculated member on our demo account it works as expected.
Try checking if “MyString” doesn’t include any lowercase/uppercase characters because the “Matches” method is case-sensitive.
If that didn’t help, either share your report definition here or contact support@eazybi.com with more details about this calculation