You may want to try using another approach: counting issues having the transitions to. “Reopen” during sprint time, instead of counting issues with this value “Yes”.
For that, use either transition status “Reopened” (if you have such) or transitions that are considered as reopening accordingly to your workflow (Done => Open, Done => In Progress, etc.) together with measure "Transition to status issues count".
If you have a particular status Reopened, you may create a measure with a tuple:
([Measures].[Transitions to status issues count],
[Transition Status].[Reopened])
Otherwise, use transitions you consider as reopening. Start with creating a calculated member in Transition dimension where you aggregate all reopening transitions, for instance, as the following (I name the calculated member “Reopened transitions”):
Aggregate({[Transition].[Done => In Progress],
[Transition].[Done => To Do],
[Transition].[Done => Review]})
Use your transitions!
Finally, use this calculated member in the measure with the code:
([Measures].[Transitions to status issues count],
[Transition].[Reopened transitions])
Measure “Transitions to status issues count” would take into account only transitions happened during the selected sprint.
