Forum Discussion
ericsara
Helper I
Helper IGet Max count when grouped by day
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....
Summarize your second table and take max out of it,
you have to create a measure for that which uses MAXXmaxRowCountInDay = MAXX(SUMMARIZE(Sheet1,Sheet1[Date],"CountColumn",DISTINCTCOUNT(Sheet1[Ticket Number])),[CountColumn])
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])