Comparing Values Between Dimension Members (Fix Version and Planned Release)

Questions & Answers
1

Hello, I have spent the better part of this afternoon attempting to obtain a summation of issues returned that have a matching member value in 2 different dimensions.

First dimension: Fix Version - can contain multiple string values
Second dimension: Planned Release - can contain multiple string values

i.e. For a given issue, Fix Version value is Release x, Planned Release value is Release x, Release Y , and issue is closed. This measure should return a 1, indicating there was a match between values in the dimensions and the issue was closed.

Report is formatted as follows:
Rows: Issue Type, Planned Release

Issue Type contains an aggregate of 4 issue types:
Aggregate(
{[Issue Type].[Story], [Issue Type].[Change Request], [Issue Type].[Defect], [Issue Type].[Task]}
)

Planned Release contains a list of each release that exists in Fix Version. This was a custom field added by the Jira admin team that has an entry for each defined Fix Version. This field represents the intended (planned) release a ticket is expected to be delivered within. i.e. when a new Fix Version is created in Jira, the Planned Release field has the same value available. Planned Release is imported into EazyBI as a dimension.

Columns: Measure in question
I am looking for help generating this measure that iterates through all issues, adding a 1 to the counter for any matches in Fix Version and Planned Release and the issue is closed.

This is what I have so far after several attempts, which seem to be getting worse each time. :):
SUM(
Filter(Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Fix Version].CurrentMember MATCHES [Planned Release].CurrentMember),
1
)

I appreciate your help, and am willing to share more details as requested.

2

Hello @kent.simpson ,
You can try using this formula:

Sum(
  Filter(
    DescendantsSet([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issue fix versions] <> "(no version)"
    AND
    InStr(
      [Measures].[Issue fix versions],
      [Planned Release].CurrentHierarchyMember.Name
    ) > 0
  ),
  [Measures].[Issues closed]
)

The Filter() function applies two conditions:

  • [Measures].[Issue fix versions] <> "(no version)" - Only includes issues that have at least one fix version
  • InStr([Measures].[Issue fix versions], [Planned Release].CurrentHierarchyMember.Name) > 0 Only includes issues where the current Planned Release appears within the Issue fix versions string

The issues are summed by measure “Issues closed”: https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-Statusesandhistory

Kind regards,
Gerda // support@eazybi.com