Your CalcDate is probably not a date, but a timestamp. Thus you get lot of unique values, but formatted they look as same date.
Try changing to your load script to something like
Date(daystart([Submit Date]),'DD/MM/YYYY') as CalcDate,
this will remove the time from the timestamp (like floor(timestamp) will also do).
Hope this helps,