Measure : Iterate over Stories sub-tasks


I created a new measure, and for each Story, I try to Sum some information from all the sub-tasks.

I’ve tried the following, but no way:

DescendantsSet([Issue].CurrentHierarchyMember, [Issue].CurrentHierarchy.Levels(‘Sub-task’)),
([Measures].[Workdays in transition status], [Transition Status].[In Progress])

And here the error message.

#ERR: Level ‘Sub-task’ not found in hierarchy ‘[Issue]’

any idea ?

Your calculation will work only for Issue.Sub-task hierarchy from the “Issue” dimension.
Try selecting the right hierarchy from the “Issue” dimension.

Martins / eazyBI

1 Like