Unique Person based on accounts.

[Anonymous]

Hi All,

With a measure how do you find Unique person beind every team Number. For Example Account name A has 2 people but Person will be counted as 1 and other example be Josh1 has serval account name with single person the count will be 1. Result as shown in Result table.

Table1
Person	Account Name
Jake	A
Jhon	A
Joy	B
Roy	C
Tim	D
Tina	E
Josh	F
Ryan	F
Josh1	Z
Josh1	Y
Josh1	X
Josh1	U
Josh1	W

Result

Result	Account Name
Jake, Jhon	1
Joy	1
Roy	1
Tim	1
Tina	1
Josh	1
Ryan
Josh1	1

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can create a calculated column as below to get it:

Result = 
CONCATENATEX (
    FILTER ( 'Table1', 'Table1'[Account Name] = EARLIER ( 'Table1'[Account Name] ) ),
    Table1[Person],
    ","
)

Best Regards