How can i to bring a number of issues linked in a Epic

Questions & Answers
1

Hello Community,

I’m trying to bring the exact number of issues linked in the epic and I’m not succeeding.
I saw similar problems here in the community but they didn’t fit my report. Should this number appear in “Issue created”? I tried to create the measure Count([Issue.Epic].Currentmember.Children) but it didn’t work either. What could I be getting wrong?

image
image1402×664 41.7 KB

Thanks

2

Assuming you are bringing in issues by epic, you can create a calculated member that checks for children and displays the count.

CASE WHEN
  [Issue].CurrentHierarchyMember.Children.Count > 0
THEN
  [Issue].CurrentHierarchyMember.Children.Count
END
3 Likes
3

Tks so much Angelescu! It’s working here :pray:

1 Like
4

Hi @Cinthia and thanks @Angelescu for the solution! :tada:

Note that this will return the count of direct Epic children like Tasks and Stories. Since the Sub-tasks are children of children, they will not show up in this count.

For this you can apply the DefaultContext() function to the measure you’re using to cancel all the filters and report context for this measure. Inside the function, use a tuple to point to the necessary measure and the context elements that you don’t want to ignore, like the current Epic in the row.

DefaultContext(
  (
    [Measures].[Issues created],
    [Issue].CurrentHierarchyMember
  )
)

​Best regards,
​Nauris

1 Like