Story points completed per Epic divided by Total Completed per Sprint

Hi, I currently have a list of epics in each sprint and story points that were completed for each of this epics. I am looking to convert story points completer per epic and divide that by the total completed in the sprint to get a %. The goal here is to determine what % of story points in a sprint were spent on which epics.

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

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

Kindly,
Janis, eazyBI support