Solved: DISTINCTCOUNT with uppercase or lowercase

Anonymous · ‎05-31-2022

Hello,

I need some help.

I have a column like that :

and if i use DISTINCTCOUNT 'Table'[Profile] i got 3 as answer

But i would like it to be case sensitive and to obtain 5 as answer. (a,A,b,B,C)

How do you do that?

Thanks.

NickolajJessen · ‎05-31-2022

Well, the bad news is that Dax doesn't distinguish between upper and lower case letters.

The good news is that power query does.
What you can do is a GROUP BY in power query and then COUNTROWS in the grouped table.

View solution in original post

NickolajJessen · ‎05-31-2022

Well, the bad news is that Dax doesn't distinguish between upper and lower case letters.

The good news is that power query does.
What you can do is a GROUP BY in power query and then COUNTROWS in the grouped table.

Anonymous · ‎05-31-2022

Hello,

That's what i thought.

Guess i will rename it in power query since i need to do more than COUNTROWS.
I will open an other discussion for that.

Thanks
Have a nice day.