Hi all,
I have a field “Status” that takes 4 distinct values. When I try to count the number of times each value occurs, it gives me false results. I also tried to create a calculated field with countIf function and still gives wrong results. For e.g, in table below you see it only counts records with values “Overdue” and “Completed” where it should also count records with “Planned” and “In Progress” values. Please also note that even for the records that displays results (“Overdue” and “Completed”) the numbers are also wrong since I have thousand of these records. What am I missing here? Thx!
Hello,
That is very strange indeed, I can see from your screenshot that you are not using any filters so that looks like it is not the case, the only thing that I can think of is that there is a problem with the dataset itself. Are you using SPICE or Direct Query? If you are using SPICE, can you check that your dataset has been loaded completely? You can see if there are any skipped rows in the refresh session.
Kind regards,
Andres.
Hi @andres007 . Good point there, I use SPICE and all rows of the dataset have been ingested successfully. I am losing my mind here! Something is really wrong, how can this be possible? I have counted distinct values of fields in the past and it was working. Do you think that could be a bug??
Hi,
If you are sure there are no filters on the dataset or the visual, If you havent tried, please create a new Analysis with the same dataset and see if that changes anything. Another things I would try is to see if the data is also missing in other visuals, like, e.g. a pie chart.
If nothing helps, I will try recreating the dataset, maybe something went wrong during the creation.
If you are still not able to make it work after all those extra tests, let me know trough here and we can find out how to proceed.
Kind regards,
Andres.
@andres007 Thanks a lot. Your suggestion to create the dataset from scratch worked. Now everything is in place 
1 Like
