Create calculated measures based on some filtering criteria - labels, projects, etc

martins.vanags · February 12, 2025, 11:51am

Label is a multi-value field in Jira and eazyBI imports it by deafult as multi-value field which would make almost impossible to filter using “except” filters.
it would require complex calculations

Please find this community post: Jira JQL in EazyBI Custom Measure as a Filter - #2 by Elita.Kalane

You could try using CSV feature for new label dimension to import second label dimension “alternative labels” with additional “Alternative Label CSV” dimension where you could create calculated member which groups all possible label combinations that you want to filter in your report.
Try this code for the calculated member in “Alternative Label CSV” dimension:

Aggregate(
  Filter(
    [Alternative Label CSV].[Alternative Label CSV].Members,
    [Alternative Label CSV].CurrentMember.name matches ".*Release-.*"
    AND
    Not [Alternative Label CSV].CurrentMember.name matches "Blocker-Release-.*"
  )
)

Then filter report by new dimension as page filter and show “Label” dimension in rows at label level to show count of issues for each label if they meet the csv criteria (has any of Release-x but don’t have “Blocker-Release” label).

Martins / eazyBI