How to get all issues that do not have a specific label

Questions & Answers
, , ,
2

Hi @1117 ,

The Except() function doesn’t handle multiple-value field dimensions the same as single-value. The best approach, in this case, is to define a new calculated measure that subtracts the number of issues with the specific label from all issues. See the formula using the measure “Issues created” as its basis below:

([Measures].[Issues created],[Label].DefaultMember)
-
([Measures].[Issues created],[Label].[not-for-qa])

Best,
Roberts // support@eazybi.com

1 Like