Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Handling Case Sensitivity in Power BI

Hi,    The table has column name  "Tags" under which it has three values-  [ "name", "Name", "NAme"]   I need a distinct count answer to be 3 not as 1, Total = DISTINCTCOUNT('table'[Tags])   I...
Need Help
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous ,

The main Power BI engine (that means datasets, relationships, DAX etc) is case insensitive while the Power Query engine is case sensitive. 
Here are the articles for further reading and possible solution:

https://www.sqlbi.com/articles/letter-case-sensitivity-in-dax-power-bi-and-analysis-services/

https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/

https://www.excelcampus.com/powerquery/count-unique-rows-power-query/ 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.