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
UK_User123456's avatar
UK_User123456
Icon for Resolver I rankResolver I
7 years ago

The calculation in my data set is 

 

Code Rank =
CALCULATE(
MIN('Table 1'[Code] ),
'Table 1'[Code Rank (ASC)] = 1
)
 
I then wanted to do a distinct count or a count based on the ranking that equals to 1 
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi UK_User123456 ,

 

I am now confused and not very much clear with your requirements.

Your first post says you want the count of codes, but now it says it is based on different data.

 

Could you be more specific or provide some sample data?

With your sample data and specific requirements it would be easy for us to resolve your issues ASAP.

 

Thanks,

Tejaswi