Hi @kovanp
Yes, dealing with labels is tricky, as “Labels” is a multivalue field.
You are on the right track with iterating through issues and applying the filter condition; only an aggregate is missing over the set, and you need to create a calculated measure instead of a member in the Issue dimension.
So, you need to define whether you want to get the sum or average values (or Min, Max, Median, etc.) and with what measure (issue count, resolved issues count, logged hours from those issues, etc.). Read in the documentation how to create a measure with Sum(): Sum , and one more example with Descendants() function used in Sum calculation: Descendants
In your case, for example, the count of all issues not matching the mentioned label would be the following:
Sum(
-- set expression
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
--filter issues by by label name
[Measures].[Issue labels] NOT MATCHES ".*bypasstest.*"
),
-- apply numeric expression on the issues from the filtered set
[Measures].[Issues created]
)
You may check other approaches how to excluding labels: Calculated member excluding some labels - #2 by zane.baranovska
Best,
IlzeLA, support@eazybi.com