Distinct Count

[_Junayetrahman]

 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.

[djurecic]

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.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data#showing-items-w...

Also, you might double check the data to see if it is actually blank vs a space, especially if DISTINCTCOUNT is returning 11.

[djurecic]

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

[_Junayetrahman]

Been using DISTINCTCOUNTNOBLANK only still showing 11