To get the total number of “Hours spent” from issues in the Sprint they were closed, try creating a new calculated measure with the formula below:
[Measures].[Sprint issues completed] > 0
), ([Measures].[Hours spent],[Sprint].CurrentHierarchy.DefaultMember)
It will get all the issues that were completed in the current Sprint and sum up the “Hours spent” in those issues disregarding the current Sprint.
Visit the eazyBI documentation page for more information on calculated measures - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members.
Roberts // firstname.lastname@example.org