Forum Discussion

UK_User123456's avatar
UK_User123456
Resolver 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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi UK_User123456 ,

 

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:

 

Thanks,

Tejaswi

  • UK_User123456's avatar
    UK_User123456
    Resolver I
    7 years ago

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

    • UK_User123456's avatar
      UK_User123456
      Resolver I
      7 years ago

      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.

       

       

      • UK_User123456's avatar
        UK_User123456
        Resolver 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