Forum Discussion

ericsara's avatar
ericsara
Icon for Helper I rankHelper I
3 years ago
Solved

Get Max count when grouped by day

So I  have a set of data like this:

Ticket NumberDate
11/1/23
23/3/23
33/3/23
43/3/23
55/523
65/523

 

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

DataCount
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

Need Help
  • RaocoSolutions's avatar
    RaocoSolutions
    3 years ago

    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])

     

1 Reply

  • RaocoSolutions's avatar
    RaocoSolutions
    Regular Visitor
    3 years ago

    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])