Text Distinct Count

[Anonymous]

Hi All,

I have a dataset similar to the below.

Date	ID	Fail Reason
01/01/2021	1	Too big
01/02/2021	1	Too small
02/01/2021	2	Incorrect
03/02/2021	3	Too big

Column 'ID' is marked as a text field. I am trying to do a distinct count of column 'ID' which reffering to the above dataset should return 3.

Putting the column 'ID' into a card visual and summarizing to Distinct Count is returning 4 and summarizing to Count is returning 4.

Any ideas as to why I am not seeing the desired 3 answer?

[amitchandak · Accepted solution]

@Anonymous , Refer @Arul  solution. Also, check do you have some space around the other 1. Use trim and lean in power query to clean ID column

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4

[Arul]

Hi @Anonymous ,

I am getting the correct value while using the sample dataset with which you were provided. I have used Count (Distinct) option.

Thanks,

Arul