How to filter unwanted statuses

Hello Rafael

See Aggregate and Calculated measures and members

A very simple example: How do I group users under a single row? (Logged by) - #2 by VasileS

Add a new calculated member in “Status” dimension:

Aggregate({
   [Status].[Open],
   [Status].[In Progress], 
   -- ......
   --everything but [Status].[Canceled]
})

Hope it helps!
Kind regards,
Vasile S.

2 Likes