Issue with category "done" exclude status "DUPLICATE" or "OBSOLETE"

Questions & Answers
,
1

Hello,

I would like create a custom measure to filter issues with [Status.Category].[DONE] and without status [DUPLICATE] and [OBSOLETE]

Aggregate(
Except(
[Status.Category].[Terminé],
{ [Status.Category].[Terminé].[DUPLICATE],
[Status.Category].[Terminé].[OBSOLETE]
}
)
)

This don’t work, I have all status in category [DONE]

Thx

2

Hi,

The formula is close to what it should be. The first parameter of the Except function must be the set. In this case, we need to take all the children of the status category. The following formula aggregates all the statuses from the Done category, except closed:

Aggregate(
  Except(
    [Status.Category].[Done].Children,
    {
    [Status.Category].[Done].[Closed]
    }
  )
)

Kindly,
Janis, eazyBI support