Counting the number of distinct values against each entry

[Anonymous]

Hello. I'm trying to visually display the number of services each person in my company is using. My table is something like this:

Name            Service

A                      B

A                      C

A                      D

B                       E

B                       F

I think I first have to create a new column which contains a count of the number of unique entries in the Name column but its not giving the right result

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

This measure will give you the distinct count of services

Service Count = DISTINCTCOUNT ( YourTable[Service] )

Then you pull the name from the table and this measure into your matrix to get your count.

[Anonymous]

If it's a table of 100 names, is there a way of avoiding pulling each name individually?

[jdbuchanan71]

You just drag the name field into the visual, not the name themselves.  It will bring all the names at once.