Forum Discussion
Solved
Incorrect Count Distinct in Table and Visualization
I am facing an issue where the *Count Distinct* for a field (`Connected`) is incorrect in visualizations like tables and decomposition trees. For example, for `Division Name: Bangalore`, the database...
There are null values (blanks) in the data so technically the result looks correct but not what you want.
I think you can use DISTINCTCOUNTNOBLANK in a measure for this.
Use +0 if you want to force a 0 result when it would otherwise be blank
There are null values (blanks) in the data so technically the result looks correct but not what you want.
I think you can use DISTINCTCOUNTNOBLANK in a measure for this.
Use +0 if you want to force a 0 result when it would otherwise be blank
Thank you so much for helping me fix this.