How to write a dimension which will work on NOT functionality for Labels type field

Questions & Answers
, , ,
1

Hello Team,

We want to write a dimension which will help us filter the issues with “NOT” clause for example

Tags (Labels type field) NOT IN (“Reporting”, Java)

Here the options may vary based on the data in the issue and “Tags” field is of type labels.

2

Hi @Pushpkant_Garg
​
​Thanks for your question!
​Considering you have imported Tags as a property, you could try the following calculated measure:
​

NonZero(
  Count(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      CoalesceEmpty([Measures].[Issue Tags], "") NOT MATCHES ".*Reporting.*|.*Java.*"
      AND ([Measures].[Issues created] > 0)
    )
  )
)

​
​ Best wishes,

Elita from support@eazybi.com