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
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
Icon for Resolver I rankResolver I
7 years ago

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

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