Different analysis depending on Query mode (Spice, Direct query)

I have a problem with dataset. I’ve created new dataset from aws athena view. Below you can find my analysis. Is anybody have similar problem? How to fix it? In Direct query mode, working correct.

is this analysis from SPICE dataset? and what is the expected analysis from the direct query mode so we can compare the two. can you put that as well?

There was an error in dataset. Some nulls were marked as NaN or NaT or etc. Quicksight SPICE couldn’t work with it. Check this out → Troubleshooting skipped row errors - Amazon QuickSight