Error when counting

Questions & Answers
1

Hi all!
Im tying to create this count filter

Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    [Measures].[Issues created] > 0
    AND NOT IsEmpty([Measures].[Issue labels])
    AND NOT IsEmpty([Measures].[Issue affects versions])
    AND (
      [Measures].[Issue affects versions] MATCHES
      ExtractString([Measures].[Issue labels], "(\d\.\d\.\d)")
    )
  )
)

But its only show me the count on individual issue and I get the following error:

#ERR: mondrian.olap.fun.MondrianEvaluationException: Expected value of type BOOLEAN; got value 'mondrian.olap.fun.MondrianEvaluationException: Exception while executing function MATCHES: java.lang.NullPointerException ' (class mondrian.olap.fun.MondrianEvaluationException)

Screenshot 2023-12-13 at 12.20.50
Screenshot 2023-12-13 at 12.20.502474×594 103 KB

How can i show it like “Issues created”?

2

I Think i found the solution
Please let me know

Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    [Measures].[Issues created] > 0
    AND NOT IsEmpty([Measures].[Issue labels])
    AND NOT IsEmpty([Measures].[Issue affects versions])
    AND InStr([Measures].[Issue labels], [Measures].[Issue affects versions]) > 0
  )
)
3

Hi @Eldar_Mondrer ,
MATCHES is sensitive to empty values and in those cases you can use CoalesceEmpty() to replace empty value with an empty string (e.g. CoalesceEmpty([Measures].[Issue affects versions], "")).
But it looks good that you already found an alternative with InStr() :+1:

best,
Gerda // support@eazybi.com