Issue with DistinctCount and displaying count

I have a table that lists ticket_number as the primary key, each with a unique number. Each ticket has a date_opened and a date_closed value. Those valuses are DATE format. I wanted to have a bar chart visual that would show how many tickets where opened by day. I have tried both making a measure with CALCULATE(DISTINCTCOUNT(table[ticket_number]) and I have tried just adding the date_opened field in the X-Axis and ticket_number in the Y-Axis with the summarization set to DISTINCTCOUNT. Both give me the result below with appears to simply show a slice for each ticket, with hundreds of slices for each day, not an aggregated number. I have also seen the same behavior with visualizing the data as a table - it just lists multiple lines of the same date opened value with a count value of 1. How can I get it to show the aggreagated count for each date?