Story points completed per Epic divided by Total Completed per Sprint

Questions & Answers
2

Hi,

The solution depends on which dimension you are using to show the list of epic.
In case you are using the Epic Link, the formula is the following:

CASE WHEN
([Measures].[Sprint Story Points completed],
 [Epic Link].DefaultMember)>0
THEN
[Measures].[Sprint Story Points completed]/
([Measures].[Sprint Story Points completed],
 [Epic Link].DefaultMember)
END

image
image.png2138×636 76.2 KB

You can also use the Epic level of the Issue dimension in your report; then the formula is the following:

  CASE WHEN
    ([Measures].[Sprint Story Points completed],
     [Issue.Epic].CurrentHierarchy.DefaultMember)>0
    THEN
    [Measures].[Sprint Story Points completed]/
    ([Measures].[Sprint Story Points completed],
     [Issue.Epic].CurrentHierarchy.DefaultMember)
    END

image
image.png2208×1094 160 KB

Kindly,
Janis, eazyBI support