Counting measure with EazyBI sum and filter

[Victor Seger]

I need to make the following measure to sum the values:

([Measures].[Transitions to],
 [Transition Field].[Sprint status],
 [Sprint Status].[Active],
 -- An issue was in a sprint at a sprint start time
 [Issue Sprint Status Change].[Future => Active],
 [Time].CurrentHierarchy.Levels('Day').DateMember(
 [Sprint].CurrentMember.get('Start date')
 )
) 

How can i do this?

Thank you.

Victor Seger

[eazyBI Support]

Hi, Victor,

To count the issues committed for several sprints, you need to use another measure counting the issues not transitions and omit the [Time] dimension member in the tuple.

([Measures].[Transitions to issues count],
 [Transition Field].[Sprint status],
 [Sprint Status].[Active],
 -- An issue was in a sprint at a sprint start time
 [Issue Sprint Status Change].[Future => Active]
)