Translating a JQL with linked issue function to calculated measure

Question

Hi all,

I need some help translating this JQL to a calculated measure in eazyBI report so that i can filter issues based on labels of linked issues

issueFunction in linkedIssuesOf(“type in (‘L1 Technical Feature’, ‘L2 Technical Feature’) and labels= PI2025.5”, “is implemented by”)

Thanks in advance

Christos Markoulatos -Relational- · Accepted Answer

Hi @dIVYA:SUNDARESHAN

Easybi uses MDX, check the documentation:

Calculated measures

Something like

CASE WHEN
  Count(
    Filter(
      [Issue].[Issue].GetLinkedMemberNames("is implemented by"),
      [Issue].[Issue].CurrentHierarchyMember.get('Issue Type') MATCHES "L1 Technical Feature|L2 Technical Feature"
      AND
      [Issue].[Issue].CurrentHierarchyMember.get('Labels') MATCHES ".*PI2025.5.*"
    )
  ) > 0
THEN 1
ELSE 0 END

should work i believe, haven't tested it though