Extract distinct values from cell

[KL718]

HI, I have data refer data in column "Names". I need output which is shown in Distinct Values. I do not need Measure, need calculated column. Thanks in advance

Names	Distinct Values
AABBC	3
AA	1
AB	2
DF	2
DDDE	2

[Zubair_Muhammad]

@KL718 

Try this calculated column

separateletters =
COUNTROWS (
    SUMMARIZE (
        ADDCOLUMNS (
            GENERATESERIES ( 1, LEN ( [Names] ) ),
            "letter", MID ( [Text], [Value], 1 )
        ),
        [letter]
    )
)

[Zubair_Muhammad · Accepted solution]

@KL718 

Minor correction.

This works with me

separateletters = 
COUNTROWS (
    SUMMARIZE (
        ADDCOLUMNS (
            GENERATESERIES ( 1, LEN ( [Names] ) ),
            "letter", MID ( [Names], [Value], 1 )
        ),
        [letter]
    )
)

[KL718]

Hey, Thanks