How to associate changing team size with sprint data

I created a CSV with Team Size by Date and loaded it as a source file into the same cube with my Jira Software sprint data. I’d like to use the start date of a Sprint to find the corresponding team size, and then use that in calculations.

First is the "Cumulative Team Size’ measure, defined as the following:

[Measures].[Cumulative New Hires] =
Cache(
Sum({PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember},
[Measures].[New hires]
)
)

This correctly works with the time dimension to produce the expected groupings for the past 5 years of data.

So then I tried to get this to work with Sprint dimension data in a calculated measure that uses a tuple with the second argument being the time dimension to force it to always be the Start date of the Sprint for the current cell.

It doesn’t work and produces nothing for each Sprint, where I know the dates should produce something. Hard to debug what’s going wrong. I tried changing the second argument of the tuple to just lookup a known date and that didn’t work either, so thinking I’m doing something fundamentally wrong.

Any suggestions?

Thanks,
Mike.

I guess there’s something special about the [Sprint] dimension – it does not have a DefaultMember so the Cumulative New Hires measure was not finding a unique cell in the cube.

Fix is to force it in the tuple:

Thanks,
Mike.