Unique number of customers

[Anonymous]

Hi

I've trying to achieve the following requirement.

I've a table of Part numbers and customers who bought those part numbers. I wish to create a table that contains unique part numbers and next to it, number of unique customers per part number.

Below is example of the data:

Part #	Customer
A-123	Customer A
A-123	Customer B
A-123	Customer C
A-123	Customer D
B-456	Customer B
B-456	Customer B
B-456	Customer A
B-456	Customer A
C-789	Customer B
C-789	Customer C
C-789	Customer C
C-789	Customer A

Below is example of the result I wish to get.

Part #	# of Unique Customers
A-123	4
B-456	2
C-789	3

[TheoC]

Hi @Anonymous 

You can use Measure = DISTINCTCOUNT ( Table[Customer] ) to achieve this.  Just create a table with Part # on left and the new measure on the right.

In addition to the above, you can simply have the Table visual with the Part Number on the left, then drag the Customer field on the visual as well.  Click the down arrow on Customer, then click on Count (Distinct).  This will achieve the same outcome without any code.

Theo 🙂

[amitchandak · Accepted solution]

@Anonymous , You can create a measure

distinctcount(Table[Customer])

And use that in visual with item #

Or create a new tbale

summarize(table, Table[Item #], "Cust", distinctcount(Table[Customer])  )

[Anonymous]

Interesting! @amitchandak 

I had similar approach where I tried to use 

VALUES('table'[Item #]) instead of Table[Item #]

So, does Table[Item #] return unique values when using Summarize?