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
"Expected Behavior:
The `Count Distinct` for the `Connected` field should align with the database values and match across visuals." - that's a little bit obscure.
Do you mean "the total is not right" for that visual? Is it supposed to be 306 for this visual?