Filter issues using summary which contains a specific word

Questions & Answers
,
2

Calculated members in Issue dimension might lead to performance problems. if you have a specific measure, you can use issue level calculations and use this filter directly in each formula.

For example, you can use this formula instead of Issues created:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Issue].CurrentMember.Name MATCHES ".*test.*"
    AND
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
  ),
  [Measures].[Issues created]
)

Please note, issue level calculations might need additional filtering by properties in larger accounts. They can still work slow.

You can also consider using some javaScript calculated custom field that will mark issues with specific values in summary during import. See thread here:

Daina / support@eazybi.com

1 Like