what are the specific step by step instructions to code calculated member formula to OMIT issues from a report with a specific label or labels.
i haven tried column filtering (did not work) i have tried - Define Calculated Member formula** - copied the filter formula from documentation but that did not work.
used this
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Measures].[Issue labels] NOT MATCHES ‘.bypasstest.’
)
got this error
Formula is not valid:
Member expression ‘Filter(Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]), (NOT ([Measures].[Issue labels] MATCHES “.bypasstest.”)))’ must not be a set
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