Number of JOIN_COUNTS doesn't match with actual scenario

[HarshilSaraiya]

Hello, 

I am trying to do Spatial Join for my Hexagonal Tessellations (Grids) with a point file.

When I do the spatial join, with following conditions - REFER PHOTO provided below - and cross check the JOIN_COUNTS in attribute table, with what I see on a map....

many of them doesn't match in terms of number of points per hexagonal grid.

Please help and guide me with this on what I am doing wrong and as I have tried multiple other options like using contains, etc. instead of Intersect in Join operation...  OR suggest an alternative for this, as I am trying to do a Optimized HotSpot Analysis through those counts.

Thank you.

[JonathanNeal]

@HarshilSaraiya Via your screenshot 2.png file.  There is a JOIN_COUNT = 10 and 4 visible points within the Hexagon.
Can you use the MapView selection tool and select all 4 points.  At the bottom of the mapView, you should have a selected items count of 10 if all is correct.
If all is correct, you have coincidence points.  (Points with the Same X,Y)

[Vikhyat]

@HarshilSaraiya .

Adding on to @JonathanNeal reponse. You can follow the instructions in the following article : https://support.esri.com/en-us/knowledge-base/find-duplicate-or-coincident-features-1462481752296-00... to check for coincident points