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 would be the correct DAX to avoid count of blank? Thanks.
3 Replies
Hi _Junayetrahman ,
Please use the DISTINCTCOUNTNOBLANK function if you don't want to count blanks.
https://learn.microsoft.com/en-us/dax/distinctcountnoblank-function-dax
Been using DISTINCTCOUNTNOBLANK only still showing 11
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.
