topic Re: Count distinct values (Names) from Names Row containing multiple names in DAX Commands and Tips

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

Anonymous — Fri, 13 Mar 2020 20:08:25 GMT

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 — Fri, 13 Mar 2020 19:28:20 GMT

Hi Anonymous

try to create a measure

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

Anonymous — Fri, 13 Mar 2020 19:33:26 GMT

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 — Fri, 13 Mar 2020 19:50:47 GMT

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 — Fri, 13 Mar 2020 20:09:01 GMT

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.