Handling Case Sensitivity in Power BI

Hi Anonymous 

In desktop, DAX is case-insensitive, so if you type directly, all you get is 1 .But you can enter the data in Query Editor . I will introduce the steps of this operation , you can refer to it .

(1)Transform Data in desktop of Power BI , and add a new Blank Query .

(2)Enter the following formula (Character.FromNumber(8203) is distinguished from other values as a character, but it is invisible in desktop and does not take up space ) .

let

    Source =#table(

    type table [Tags = text],

        {

            {"name" },

            {"Name" & Character.FromNumber(8203)},

            {"NAme"& Character.FromNumber(8204)}

    })

in

    Source

(3)Then back to desktop , in the Data View , you can see the table.

(4)Create a measure to count the value of Tags .

Total = DISTINCTCOUNT(Query1[Tags])

The effect is as shown:

I have attached my pbix file, you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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