I am trying to count stories on any released version while having a Page filter to be able to filter the stories by version.
The expression that I am using to count “Released Stories” only works if I filter “All Fix Versions”. It uses the [Fix Version] dimension, which is filtered and so it won’t work when a specific Fix version is selected on the Page filter drop-down.
Released Stories = Sum( Filter( [Fix Version].[Version].Members, [Fix Version].CurrentMember.Parent.Name = "Released" ), [Measures].[Closed Stories] )
Is there any property on the Issue dimension that I can use to get the fix versions and check if any of them are released? Any other solution?
I am including a picture that better explains the problem.