max of grouped sum

[AvnerBZ]

Hi

I have a table of bus stops 'BusStops' where every row is a stop on a specific station
Columns:
'HourAtStop' which is the hour when the bus is in the station (6,7,8...)
'Start/End' which tell if is the bus is 'starting', 'finishing' or 'PassingBy'.
i want to make a measure that will tell me what is The busiest hour on the station, and how many stops there is on this hour in this station.

Thanks

[Anonymous]

File attached.

Best

D

[Pragati11]

Hi @AvnerBZ ,

Can you please share some screenshots around sample data and the desired output?

Thanks,

Pragati

[AvnerBZ]

BusStops
StopID	LineNumber	HourAtStop	BusyHourAtStop	DepBusyHour
111	19	7	7	4
111	19	7	7	4
111	19	8	7	4
111	17	7	7	4
111	17	7	7	4
112	23	10	10	3
112	23	10	10	3
112	24	10	10	3
112	24	11	10	3
112	25	11	10	3
112	25	12	10	3

'BusyHourAtStop' and 'DepBusyHour' are the desired output