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
The total for the Connected field in the visual seems to be inaccurate. Based on the database query results, DNIS ending with 555 has 295 calls in the database. The other DNIS values shown in Power BI are showing as 0 in the database. Additionally, an extra record appears in Power BI. I have attached the database query results for reference to assist in troubleshooting