Sum tickets filtered by status

Questions & Answers
1

Hello I’m trying to create a measure that Sum ONLY the children tickets with status NOT started

image
image826×473 41.6 KB

Can you help me with the formula?:

Sum(
Filter(
ChildrenSet([Issue].CurrentHierarchyMember) AND
[Status].[Not Started]
,
[Measures].[Issues created]
))

Thanks!

2

Hi @Pedriel

Please try the following formula:

Count(
  Filter(
    ChildrenSet([Issue].CurrentHierarchyMember),
    (
      [Measures].[Issues created],
      [Status].[Not Started]
    ) > 0
  )
)

Let me know if this works as expected!
​Best regards,
​Nauris