Pivot Table is broken when I add a data range dimension

So basically, I have a pivot table, using a database that is a snowflake query. I have one dimension per row/column and I have a metric. If I add a data range dimension, the metrics is completely broken. The values seem correct whenever there is no data range dimension, but whenever I add it, they are broken and much larger then without the data range dimension, regardless of the dimensions used on row and column. What could be the problem here? Any suggestion on how to debug this?