Count or distinct count

Question

Hi Community,&nbsp;I have a column in my data that has a type of "text" but when I try to do a count or distinct count of the data, it just doesnt work. Can anyone help?&nbsp;The example is as follows:&nbsp;Code4110 - Uni4112 - Coll4131 - Store4121 - STA4110 - Uni4110 - Uni4110 - Uni4121 - STA4131 - Store4131 - Store4121 - STA4131 - Store4131 - Store4121 - STA&nbsp;The output should be:CodeCount4110 - Uni44112 - Coll14131 - Store54121 - STA4&nbsp;Any help would be greatly appreciated.&nbsp;TIA

richbenmintz · Answer

Hi&nbsp;UK_User123456&nbsp;&nbsp;The following measures should give you the counts you are looking for&nbsp;Count = CountRows('table')Distinct Count = DISTINCTCOUNT('table'[column])I hope this helps,&nbsp;Richard

anonymous · Answer

Hi&nbsp;UK_User123456&nbsp;,&nbsp;Don't know what steps you are following .However when I tried with your example in a table Visual, I get the output as expected:see screnshot below:&nbsp;Thanks,Tejaswi

uk_user123456 · Answer

But would this work if it was referenceing a measure that was calculated?

uk_user123456 · Answer

I have a calculated measure that is based upon a ranking column in my base data, I then wanted to count the number of times those codes appear.&nbsp;&nbsp;

uk_user123456 · Answer

The calculation in my data set is&nbsp;&nbsp;Code Rank = CALCULATE(MIN('Table 1'[Code] ),'Table 1'[Code Rank (ASC)] = 1)&nbsp;I then wanted to do a distinct count or a count based on the ranking that equals to 1&nbsp;

Forum Discussion

Count or distinct count

8 Replies

Related content

count distinct

Counting nulls

Distinct Count

Distinct count

DAX Calculation for Distinct Count

Code	Count
4110 - Uni	4
4112 - Coll	1
4131 - Store	5
4121 - STA	4