Hi Laurma,
There is a hidden measure [Measures].[Transitions to] that shows wow many times during selected Time dimension period issue has changes to some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes.
You can find documentation about it here: https://docs.eazybi.com/display/EAZYBIJIRA/Import+issue+change+history
You can use that to find in what sprints issues have been and after that you can filter the issues that are open or any other result that you would like to have.
There is some discussion about it here as well: Number of Sprints for issues to get completed
Gvido Neilands,
gvido@flex.bi,
eazyBI service partner