How to get the value of Total from user calculated Measure

Questions & Answers
1

Hi guys,
I have a calculated members like this

image
image898×446 20.1 KB

And have it the total like this
image

What i want to achieve now is to make that “242” value as a new calculated measure called “Total”. Can somebody help how to achieve that?
Thanks in Advance,
Regards,
Arnold

2

Hi @Arnold_K,
You can use this formula, where at Project level it will use measure Story points created/8 (as this measure aggregates all values from below issues), but at Issue level, it will show issue parent (project) Story points created/8.

CASE WHEN [Issue].CurrentHierarchyMember.level.name = "Project"
 THEN
  [Measures].[Story points created]/8
WHEN [Issue].CurrentHierarchyMember.level.name = "Issue"
 THEN
 Nonzero(
   (
   [Measures].[Story Points created],
   [Issue].CurrenthierarchyMember.parent
   )/8)
END

best,
Gerda // support@eazyBI.com