I would like to see total hours spent for all the issues within sprint. Some of the issues span multiple sprints so when looking at the sprint in which the issue was closed, I’d like to see all hours spent on this issue, not only the hours spent within the last sprint.
The calculated measure considers issues that were completed in the particular Sprint. The condition on the measure “Sprint issues completed” [Measures].[Sprint issues completed] > 0 ensures that.
So, it could be that work was logged for a particular issue (showing up in “Hours spent”), but the issue was not completed in the specific Sprint. Thus, the calculated measure returns empty.
You can alter the condition inside the Filter() function to adjust the calculation for your requirement. See more details about the Filter() function - Filter.