Forum Discussion

UK_User123456's avatar
UK_User123456
Icon for Resolver I rankResolver I
7 years ago

Count or distinct count

Hi Community,   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?   The example is as follows:...
Need Help
richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi UK_User123456 

 

The following measures should give you the counts you are looking for

 

Count = CountRows('table')
Distinct Count = DISTINCTCOUNT('table'[column])

I hope this helps,

 

Richard