Power BI Distinct producing different result than SQL Distinct

Hi There   I have a table with column NAME and I am trying to find the total count of distinct values from NAME column. If for that I run the following SQL query  select distinct RTRIM(LTRIM(Name)...