unique name values based on phone number

[mina97]

Hey ihave the following data 

First Name	last name	email	degree	payment	ID
jack	Eden	Eden exapmle.com	bachelor	250$	2160003021
lora	Teigen	Teigen example.com	bachelor	340	3160003021
jack	Edin	Eden1exapmle.com	bachelor	600$	5160003021
jack	Eden	Eden1exapmle.com	bachelor	500$	5160003021

how can i assign uniqe ID to the most frequent first name

because i have a lot of misspelled names and i want to unifiedthem
i wrote the following dax column but it i do not know how to add the most frequent first name part

name unique = 
VAR same_names =
    CALCULATETABLE (
        SUMMARIZE ( 'Table1 (2)', 'Table1 (2)'[ID], 'Table1 (2)'[First Name] ),
        ALLEXCEPT ( 'Table1 (2)', 'Table1 (2)'[First Name] )
    )
VAR ranking = RANKX ( same_names, 'Table1 (2)'[ID],, ASC, DENSE )
VAR blanks = REPT ( UNICHAR ( 8204 ), ranking - 1 )
VAR res = 'Table1 (2)'[First Name] & blanks
RETURN
    res

Please HELP and THANK YOU

[tamerj1 · Accepted solution]

Hi @mina97 
Please try

Most Frequent First Name =
VAR SameFirstNameTable =
    SUMMARIZE (
        CALCULATETABLE ( 'Table1 (2)', ALLEXCEPT ( 'Table1 (2)', 'Table1 (2)'[ID] ) ),
        'Table1 (2)'[First Name],
        "@Count", COUNTROWS ( 'Table1 (2)' )
    )
VAR MostFrequentFirstNameTable =
    TOPN ( 1, SameFirstNameTable, [@Count] )
VAR MostFrequentFirstName =
    MAXX ( MostFrequentFirstNameTable, 'Table1 (2)'[First Name] )
RETURN
    MostFrequentFirstName