KPI Count not matching straight table

[qlikfresh]

Hey guys 

I have a KPI counting the number of times a result status appears in my straight table however the KPI count is different to when I go in and manually count the filtered items in the table

For example: if I filter for RESULT_STATUS = 'C' (complete) the KPI returns 17 when there are only 5 results in the table 

Have tried the following formulas: 

=sum(aggr(if(RESULT_STATUS='C',1,0), ID_COLUMN))

=(Count(distinct{<RESULT_STATUS = {"C"}>} ID_COLUMN))

Really not understanding how this can even be possible especially with using set analysis, any help much appreciated 

[qlikfresh]

Hi @simonaubert 

Thanks for looking in to this. 

I have taken an extract of sample data below and taken a screenshot to help you better understand

In this instance, KPI reads 22 while measure in straight table reads 10. Is there any way around this?