Count measure not counting correctly when filtering

[alespooletto]

I have an issue with my measure, which supposedly only counts specific action codes. 

The measure is 

```

COUNT( ACTION_CODE = 'LABOR_OFF')

```

But when I insert it into the table, I don't get the right counts and shows as in the screenshot that it counts also when ACTION_CODE = 'LABOR_ON' 

Is there any solution to this?

[theoat · Accepted solution]

Try this : 
Count({<ACTION_CODE={"LABOR_OFF"}>}distinct Employee)

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[Clement15 · Accepted solution]

Hello, could this be suitable?

count({<ACTION_CODE = {'LABOR_OFF'}>} ACTION_CODE )

[alespooletto]

Thank you, this gives me a 1 as result, which would work fine if I needed to check what an employee did on a specific SFC without counting all the SFCs at once. I needed one that would count, for all the SFCs done, the number of which had action code = labor off. The response by @Clement15 actually provided the solution, thank you all!