Same client ID with different name variations

[Anonymous]

I am trying to segment data from clients but I have one problem: There are different name variations (or typing errors) for the same client ID.

ID	First Name	Last Name
0918745654	Wilhelm	Schwarz
0918745654	Wilhelm	A. Schwarz
0918745654	Wilhelm	Schwartz	(Typing error)
0918745654	Wilhem	Schwarz	(Typing error)

My question is how do I create a measure that can group this names into a single one based on the unique ID.

Thank you all!

William

[Nathaniel_C]

@Anonymous ,
Try This:

First Names = CALCULATE(CONCATENATEX(myTable,myTable[First Name]," ,"),ALLEXCEPT(myTable,myTable[ID]))

Last Names = CALCULATE(CONCATENATEX(myTable,myTable[Last Name]," ,"),ALLEXCEPT(myTable,myTable[ID]))

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[parry2k · Accepted solution]

@Anonymous you can create measure to get first and last name, and write another measure for Last Name

My First Name = 
CALCULATE ( MAX ( Table[FirstName] ), ALLEXCEPT ( Table, Table[Id] ) )