Count Unique Client or Customer IDs

[Anonymous]

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 clients have taken part in various services/programs that have different start and end dates. Now, if I want to know how many unique clients IDs I have (irrespective of the service or start/end date), how can I do that? The problem is when i use a card or table visual (or anything for that matter 🙂 ), that counts the number of unique client IDs (in a single column) using distinct count, Power BI still counts more IDs than the actual answer, because of the repeats of client IDs as they are subscribed to different services. Is this because, the end dates are different for different services for each client or is it something else? I have attached a sample dataset for your better clarity. Kindly assist @amitchandak @ImkeF @parry2k and others. Thanks 🙂

[javeir_obregon]

What's the result you are expecting here?

Ron - 3

Shawn - 2

William - 2

John - 2

Chris - 4

????

[Anonymous]

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.

[javeir_obregon]

You can create a measure:

Unique Client IDs = DISTINCTCOUNT('Table'[Client ID])