How to Count Issues (History) without Story Points

Questions & Answers
2

Hi Lars,

You were on the right track with the first formula! The incorrect part there is that you first filtered ‘Issues created’ which on Timeline gives only issues created in that period. So you ended up counting just issues created at the period which do not have story points at that period.

Try the following formula - it first filters that issue is created before the end of the selected period end and then makes sure issue is created in all other report context, ignoring Time.

NonZero(Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
    ([Measures].[Issues created],
      [Time].CurrentHierarchy.DefaultMember) >0
    AND
    ([Measures].[Story Points history] = 0
      OR
      IsEmpty([Measures].[Story Points history])
    )
  )
))

Please let me know if you have further questions regarding this!
Lauma / support@eazybi.com