Count distinct values (Names) from Names Row containing multiple names

[Anonymous]

I am trying to get the disticnt count of "each" user in the coumn "Ticket opened by", any help on this please...

I am trying to find the numbers for only few users from the list.

There are more than 1000 users in that list, i just want 50 hand picked users (not top 10) but Unique individuals.

[az38]

Hi @Anonymous 

try to create a measure

Measure =
CALCULATE(DISTINCTCOUNT(Table[Ticket Number]), ALLEXCEPT(Table, Table[Ticket opened by]))

[Anonymous]

But, how will this give me distict count for each user?

For Ex: If I want to find the count of Zhou, Lin in the column??

[Greg_Deckler]

Put you Ticket Opened By column in a visual. Then put Ticket Number and do a Count (Distinct) aggregation.

Is that what you want @Anonymous ?

[Anonymous]

Hey, Thanks for the reply... But that's not what I am looking for.

I am trying to find the numbers for only few users from that list.

There are more than 1000 users in that list, i just want 50 hand picked users (not top 10) but Unique individuals.