DAX Distinct counts measure

[IgorGershenson]

I am using a file where the same customer ID repeats multiple times. I need to get distinct count of customer IDs so I am using Calculate(DISTINCTCOUNT(Table[ID]),ID<>blank()) but for some reason its distinct count is too high. Has anyone experienced this? 

When I export the details and pivot to see the number of distinct counts I get a slightly smaller number. I have never seen this. Should be easy. 😞

[Icey]

Hi @IgorGershenson ,

If you don't mind, please share me some data sample and screenshots.

Best Regards,

Icey

[T_Buck_1027]

I have seen this issue before, I would start by checking to see if there are any spaces before or after the duplicate IDs. If you need to trim the values in the column, make sure the column type is set to text.

[IgorGershenson]

We had trimmed the client ID before. Could it be anything else?