Re: Count distinct values (Names) from Names Row c...

Anonymous · ‎03-13-2020

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 · ‎03-13-2020

Hi @Anonymous

try to create a measure

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

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Anonymous · ‎03-13-2020

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 · ‎03-13-2020

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 ?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎03-13-2020

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.

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