Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not 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.

TimBob_0-1717417681122.pngTimBob_1-1717417706195.png

 

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.

1 ACCEPTED SOLUTION
Anand24
Super User
Super 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.

Anand24_0-1717418214392.png

 

 

View solution in original post

2 REPLIES 2
Anand24
Super User
Super 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.

Anand24_0-1717418214392.png

 

 

Anonymous
Not applicable

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.