Filter is not applied to the rows

Рустам Усманов
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 2, 2018

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. 

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events