Measure to show the number of sprints a Issue was worked

Hello everyone! I’m trying to create a measure which shows the number of the sprints a determined task was worked based on the measure “Issue Sprints”. For example, the key CAREAG-3903 should be 2 while all other should be 1.

Could you help me please?

Thanks!

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