Forum Discussion

IgorGershenson's avatar
IgorGershenson
Helper II
6 years ago

DAX Distinct counts measure

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. 😞

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi IgorGershenson ,

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

     

    Best Regards,

    Icey