Filter Issues by Text in title

Questions & Answers
1

Hi there,

I´d like to filter out issues that have a specific text in their title from the measure “Issues created”.
Can anyone provide an mdx code for a calculated measure?
Thanks in advance.

2

Hello @AntonBDR

Try using the following as a calculated measure:

Count(
    Filter(
        Descendants([Issue].CurrentMember,[Issue].[Issue]),
        [Issue].CurrentHierarchyMember.Name MATCHES '.*Foo.*'
    )
)

Replace the Foo with your search string.
You can see how to search for a regular expression here:
https://docs.eazybi.com/eazybi/analyze-and-visualize/regular-expressions

Edit: This should work for measure “Issues created”:

Count(
  Filter(
    Filter(
      Descendants([Issue].CurrentMember,[Issue].[Issue]),
      [Issue].CurrentHierarchyMember.Name MATCHES '.*Anschaffung.*'
    ),
  [Measures].[Issues created] > 0
  )
)
3

You can use a suggested formula for issues. It might be a bit risky though.

Check out this community post on this as well:

Daina / support@eazybi.com