count(field) is duplicating rows

[mtabernad]

Dear community,

I hope someone can help me since this is driving me crazy.

I have a simple table with all the fields of the model which are 9. After some date filters, only one row show up in the table but my kpi shows '2' as value.

My script is:

I would appreciate some help please!

Thank you in advance

[sunny_talwar · Accepted solution]

The table only displays unique combination of fields listed in it. That doesn't imply that Count() would equal = 1... When you see a count  = 2, it means that there are two rows where the listed dimensions appear twice. Count(DISTINCT...) will give you 1

[mtabernad]

Thanks for your quick reply. I get your point! I understand now!