The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
@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 ,
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.
Oh! I just realized have a slicer at the back of the page. Thank you so much!