Get Max count when grouped by day

[ericsara]

So I  have a set of data like this:

Ticket Number	Date
1	1/1/23
2	3/3/23
3	3/3/23
4	3/3/23
5	5/523
6	5/523

I want to count the instances of each date and get this.

Data	Count
1/1/23	1
3/3/23	3
5/5/23	2

I now want to get the Max count.  The answer being 3.

Not sure how to do this. 

Thanks for any help you can give. 

Cheers

[RaocoSolutions · Accepted solution]

Summarize your second table and take max out of it, 
you have to create a measure for that which uses MAXX 

maxRowCountInDay = MAXX(SUMMARIZE(Sheet1,Sheet1[Date],"CountColumn",DISTINCTCOUNT(Sheet1[Ticket Number])),[CountColumn])