Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Count Distinct only returns 1

Hi All, I'm having a trouble using Count Distinct as it only returns 1 value even though the column has 3 distinct value that is shown as below.

 

I've got the column in text type and the count distinct works fine with other tables. Could someone give me help or guidance regarding this problem? Thanks in advance.

  • Anonymous ,
    The most probable reason I can think of is some slicer/filter is affecting the card visual. Please check the filtering by hovering over the funnel icon of your visual.

     

     

2 Replies

  • Anonymous ,
    The most probable reason I can think of is some slicer/filter is affecting the card visual. Please check the filtering by hovering over the funnel icon of your visual.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Oh! I just realized have a slicer at the back of the page. Thank you so much!