Filter doesn't register same values as 1 after column split

[Anonymous]

I have a file with a Name column delimiited by a comma:

Abby
Brandon, Abby

Charles

Charles, Brandon

After I column split them into different rows based on comma delimiter, I get this:

Abby
Brandon
Abby
Charles
Charles
Brandon

Now this is fine the way it is. But why is it that when I use the filter to filter distinct names,
Power BI doesn't see the Abby (above Brandon) and the Abby (below Brandon) as the same name?

[NaveenGandhi]

Hi @Anonymous 

since you use delimeter after comma, the Brandon, Abby get split and Abby has a space at the start. So trim the values to resolve this issue.

let me know if this helps.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[Anonymous]

Sorry there are no spaces between the values. I just added it with space for clarity sake.
There is linebreak between them. Would that affect the value?
I've checked the values themselves and there are no space and linebreaks before them.

[NaveenGandhi · Accepted solution]

@Anonymous 

Try applying trim function, also share sample data to check from my end,

Thanks,
NG