Forum Discussion
manoj_0911
Kudo Commander
Kudo CommanderIncorrect 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
HotChilli
Community Champion
Community ChampionThere 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
- manoj_0911
Thank you so much for helping me fix this.
