Cannot get eazyBI to return same results as JQL with hierarcy

Questions & Answers
2

Hi,

I suppose your questioni in another community thread AffectsVersion not working properly? is related to this questions and the idea for the solution is the same.
However, there are differences. If you have to check issues in two levels that are directly linked (like Epics and their children via Epic link), then the calculation might be the following:

--annotations.drill_through_non_empty = false
NonZero(SUM(
     Filter(
       Descendants([Epic Link].CurrentMember,[Epic Link].[Epic]),
      [Issue].[Issue].GetmemberbyKey([Epic Link].CurrentMember.Key).get('Parent Link') = "(none)"
       and
       DefaultContext(([Measures].[Issues created],
        [Issue].[Issue].GetMemberByKey([Epic Link].CurrentMember.Key),
        [Affects version].CurrentHierarchyMember)) > 0),
    ([Measures].[Issues created],
    [Affects version].CurrentHierarchy.DefaultMember)
 ))

For this measure, you could use the option of the drill-through issue.

Best,
Ilze, support@eazybi.com