Forum Discussion
Count Unique Client or Customer IDs
Hello Friends, I am stuck at "Distinct Count" for unique client/customer IDs. Here is my what is happening: I have a huge dataset that includes clients with their respective client IDs. These...
What's the result you are expecting here?
Ron - 3
Shawn - 2
William - 2
John - 2
Chris - 4
????
Thank you for the response.
I expect the result to be as follows:
Total Count of Client IDs = 5 (Ron, Shawn, William, John, Chris)
This is irrespective of the number of times each client ID is repeated in this column.
You can create a measure:
Unique Client IDs = DISTINCTCOUNT('Table'[Client ID])