Filter out unwanted Status

I want to create a report that excludes the status of Done and Cancelled - I created a filter below that shows the Done but I want to show all status except done and cancelled

Aggregate(
Filter(
[Status].[Status].Members,
[Status].CurrentMember.Name = “Done”
)
)

Hi Brian,

In this case you may want to use a slightly different approach when creating a calculated member:

Aggregate(
  Except(
    [Status].[Status].Members,
    { [Status].[Done],
      [Status].[Cancelled]
      }
  )
)

Please find more information here:
https://docs.eazybi.com/display/EAZYBI/Calculated+members#CalculatedMembers-Aggregatemembersinotherdimensions

Best regards,
Martins / eazyBI team

1 Like