Not to count the issues whose resolution field is not empty

Questions & Answers
1

Hi,

I created this calculated measure:

Cache(
Sum(Except([Measures].[Issue resolution date]){PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember},
[Status].[Status].[Tested]
)
)

It is working well but I would like to exclude from the Sum the issues whose resolution field is not empty. Could you help me with this, please? Thank you!!!

2

Hi!! Any idea about this?

Thank you

3

Hi, @Joaquin_Gago

Thank you for your question. Sorry for not answering sooner.

I would suggest using a tuple to exclude the issues that have a resolution. Read more about it here: Tuple

For this to work properly you need to choose at least one measure - Issues created, for example. Then the formula should look like this:

Sum(
{PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember},
([Status].[Tested],
[Resolution].[(unresolved)],
[Measures].[Issues created])
)

Please, double-check the Status and Resolution names in the formula.

Kindly,
Ilze support@eazybi.com

4

Thank you Ilze, that worked!!!

Best regards

1 Like