DISTINCTCOUNT - same number but different usernames

[Daniel_F]

Hi all,

i know how to count distinct values, but in our data sometime we have same ID for different users (and this is ok) and i need to distinctcount this users like two different values, f.e.: two different persons have same ID 59566 and measure shows distinctcount result 1 but i need to see 2. Is it imposible? If yes, what should i add to my measure or maybe calculate this in other way:

Distinct = CALCULATE(DISTINCTCOUNT('table_name'[ID]),FILTER('table_name','table_name'[Status]=100))

Any suggestions? 😉

Thx in advance 😉

[jcalheir · Accepted solution]

Hi

If your ID is not unique, i could sugest you create a Surrogate Key by concatenating the ID and the username. You can to this in either Power Query or by a Calculated Column.

This way you will have a unique ID and be able to count the distincts

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Daniel_F]

Yes, you are right! 🙂

Thx a lot!