Filtering out issues without a particular label in EazyBi when including issues without any label

[Dagmara_Rosińska]

Hello,

I am trying to filter out the Jira issues with "test" label from our report. Some issues do not have a label at all so beside filtering out "test", I also need to include the issues where label is empty.

I tried:

1. [Measures].[Issues created]-[Label].[Test] - Seems to not work

2. Except([Measures].[Issues created], Label.[Test]) - It returns an error "Member expression 'Except({[Measures].[Issues created]}, {[Label].[Test]})' must not be a set"

3. Adding labels as pages, but it this seems to return some issues multiple times (when there are multiple labels) 

Thank you,

Dagmara

[Zane eazyBI Support]

Hi @Dagmara_Rosińska,

I understand that you would like to get all issues (including those issues which do not have any label) except those which have a label test. The label is a multi-selection field in Jira and issue with label test might have another label as well which complicates the use case; this is also the reason why you get one issue several times when filtering by labels.

Your first idea is good, but it would work in limited conditions and the correct way to write it down would be in Measures using a calculation like this:

( [Measures].[Issues created count],
  [Label].DefaultMember )
- 
( [Measures].[Issues created count],
[Label].[Test] ) 

Another option is to count issues without label "Test" is iterating through all issues and filter issues which have no label "Test". The formula for a calculated measure (you should build it in Measures) might look like this:

NonZero(Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    --no lable Test
    IsEmpty(([Measures].[Issues created count],
    [Label].[Test]))
    AND
    [Measures].[Issues created count] > 0
  )
))

For more details on how to build calculated measures and use functions visit the eazyBI documentation: https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members

When working with multi-selection fields in the report, you might want to use a distinct issue count measure like Issues created count. More information on available measures and dimensions you will find in the eazyBI documentation: https://docs.eazybi.com/eazybijira/getting-started/measures-and-dimensions

Best,

Zane / support@eazyBI.com