Forum Discussion
Anonymous
2 years agoNot applicable
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
- Anand24Super User
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.- AnonymousNot applicable
Oh! I just realized have a slicer at the back of the page. Thank you so much!