Measure to show the number of sprints a Issue was worked

Questions & Answers
2

Hi @Leonardo_Furone,
Welcome to the eazyBI Community :partying_face:
You can use this formula to count issue sprints:

NonZero(
  count(
    Filter(
      [Sprint].[Sprint].getMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Sprint IDs')
      ),
      [Sprint].CurrentHierarchyMember.name <> "(no sprint)"
    )
  )
)

Or see the answer from my colleague here for another approach:

best,
Gerda // support@eazybi.com