Forum Discussion

IgorGershenson's avatar
IgorGershenson
Icon for Helper II rankHelper 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...
Need Help
Tips and Tricks
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.

  • IgorGershenson's avatar
    IgorGershenson
    Icon for Helper II rankHelper II
    6 years ago

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