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.