Sum up hours spent against an epic and any child tasks and sub-tasks in eazyBI

[graemejohnson]

Hi

Please can you help?

I need a a single calculated field to work as follows.....

If I have an issue that is an epic I to sum the total hours logged against that epic or any issue attributed to the epic

If the issue is not an epic I want it to sum the total hours logged against the issue of any children

If think this (below) could achieve the latter - but I'm not really sure how to deal with the epic and how to glue it all together into a single calculated member.

Sum(Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Hours spent with sub-tasks] > 0 
), [Measures].[Hours spent with sub-tasks])

[graemejohnson]

Well.....I came up with the following - but not sure it works in all cases or is best practice.....

CASE WHEN [Measures].[Issue type] = 'Epic' THEN
Sum(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  DefaultContext(( 
    [Epic Link].[Epic].Members.Item([Issue].CurrentMember.Name),
    [Time].CurrentMember,
    [Measures].[Hours Spent]
  ))
)
ELSE
  [Measures].[Hours spent with sub-tasks]
END