Hi @doneliza and welcome to the Quick Sight community!
I wonder if when you expand the filter range, it’s affecting your calculation. Could you either share the calculated field that you’re using for this instance or upload your analysis to Arena so that we can view how your data is being affected.