Why isn't COUNT DISTINCT working properly?

[#1]

So I have a problem. With every other text box where I put =COUNT({<[Pr Yr] = {2017}, DOINVSTATUSID = {20}, LOADPRIORITYSTATUSID = {30}>} DISTINCT ITMSNumber) it works fine, but there are two text objects where the count distinct function is returning 4 of the same ITMSNumber's. It should only be returning 1 with the same ITMSNumber.

Why is this happening and how can I fix it?

[#2]

It says "Text Object"

[swuehl]

Well, hard to tell what's going on using the information provided.

There might be multiple things that may affect your distinct count() in different chart objects: Use of set analysis, alternate states, detached objects ...

[Clever_Anjos]

Is ITMSNumber a key? You should avoid counting key fields

[sunny_talwar]

Distinct counting a key field should not be a problem as mentioned my HIC here Count or Count distinct?