I am trying to create a new calculated measure which should return me the number of tickets moved to particular status from another status. I have created a formula but its not working and returning me a blank field.
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
(
[Measures].[Transition from status] = “Dev Complete” OR
[Measures].[Transition from status] = “In development” OR
[Measures].[Transition from status] = “Code Review” OR
[Measures].[Transition from status] = “Ready to verify” OR
[Measures].[Transition from status] = “In QA (UAT)” OR
[Measures].[Transition from status] = “Complete (Dev/QA)”
)
AND
[Measures].[Transition to status] = “In QA (Stage)”
),
[Measures].[Transitions to status]
)
Is there anything i am missing here?
