Forum Discussion
Distinct Count
Hello all, when I am filtering V code the disctinct count of B Code SA should show 10 excluding blank. Similarly S code should show 1. However, It is showing 11 for B code SA and 2 for S code. What...
Ok. If you don't want blank rows to appear in your visual, make sure that "Show items with no data" is not checked. This will avoid showing rows where all values are blank.
Also, you might double check the data to see if it is actually blank vs a space, especially if DISTINCTCOUNT is returning 11.