Hello!
I'm trying to get the subdimension of Issues with the following code in the easyBI:
Aggregate(
Filter(
[Issue].[Issue].Members,
([Measures].[Transitions to status issues count],
[Transition Status].[Estimation])>0
AND
([Measures].[Transitions from status issues count],
[Transition Status].[New])>0
)
)
The idea is to look only for the issues that were moved from New status to Estimation status. Almost the same code works as a measure, but when I am using the specified code, I'm getting both the required issues and the ones that do not correspond to the condition.