Forum Discussion
Text Distinct Count
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?
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
2 Replies
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
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
