Count stories in any released version while filtering a version on the Pages filter

Questions & Answers
#1

Hi,

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.

Thanks,

Enrique

report-design
report-design.png1238×356 46.5 KB

1 Like
#2

This is it.

   NonZero(Count(
      Filter(Descendants([Issue.Epic].CurrentMember,[Issue.Epic].[Parent]),
        [Measures].[Closed issues]>0 AND
        ([Measures].[Closed issues],
          [Fix Version.By status].[Released], 
          [Fix version].CurrentHierarchy.DefaultMember)>0
      )
    ))

Thanks to Janis Plume from eazyBI support.