Formula Returning Undesired Number

[cm]

Probably an easy diagnosis for you experienced people out there, but I have a KPI that's returning a wild number when I'm using a filter pane.

Objective is to show number of Gang Members arrested. Data column has many different gang names, along with "none/null", which I exclude by counting the following:

KPI expression is: count({<[Gang Name]) /= {'NONE/NULL'}>} [Arrests]).

The above expression works correctly when there are no filters. 

When I filter by a Specific Gang Name in a filter pane, however, the same KPI shows a pretty crazy number: count([Arrests]) - count([Gang Name]) + count ([Specific Gang Name]).

Using the $ modifier helps to get the KPI correct when a Gang Name filter is on, but then removing the filter returns the full: count([Arrests]).

Any advice?

Thanks!

CM

[vishsaggi]

To exclude values None/Null may be you should use like

=Count({< [Gang Name] -= {'NONE/NULL'} >} [Arrests])

and for your KPI try below?

count([Arrests]) - (count([Gang Name]) + count ([Specific Gang Name]))

[Lisa_P · Accepted solution]

Try this:

count({<[Gang Name]) -= {'NONE/NULL'}>} [Arrests]

Count arrests for selected gangs except NONE/NULL

[Channa]

count({<[Gang Name]) -= {'NONE','NULL'}>} [Arrests])