How to create a calculated member for getting the HOURS SPENT of one Epic in specific project?

My request is to get total Hours Spent from two JIRA project, I’m trying to create a calculated member as picture shown, but I don’t know how to get second part of formular, please help me to finalize the formular, many thanks.
Part 1: All hours Spent in LHRD201603 PEP project;
Part 2: All hours Spent in a Epic named “LHRD201603 PEP” in another project named LHRD202001 MVD (a software project to support all project requirements, this project used Epic to split different project)

I had found the correct formular, share for similar requester as below:

Sum(Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    [Issue].[Issue].GetMemberByKey([Measures].[Issue parent key]).GET('Feature Link') = 'LHRDPEP-12'
  )

this formular will help to get all hours spent in an Epic.

1 Like

Hi @Matt_Z,

GetMemeberByKey() is an excellent function allowing yuo to access data from related issues =)

If issues are organized in a hierarchy, like Epic or Parent hierarchy, there is an alternative solution with the tuple expression. The expression might look like bleow:

(
  [Measures].[Hours spent],
  --precise feature name in the epic hierarchy,
  [Issue.Epic].[LHRD202001 MVD].[LHRDPEP-12]
)

Best,
Zane / suport@eazyBI.com