How to count all issues resolved substracting status = Rejected

Hi

I need to create a measure to count all issues resolved but subtracting the rejected ones. I know I can do it by filtering them out but I want to have a measure that takes care of it, without requiring a such a filter for the entire graph.

Hi,

The following custom measure should do that:

[Measures].[Issues resolved]-
([Measures].[Issues resolved],
[Status].[Rejected])

Kindly,
Janis eazyBI support

1 Like