I have data that shows Location, shift, and weekday, and customer ID.
What I am trying to accomplish is finding the maximum number of customers on any day and any shift to determine the maximum customer limit at a location.
So I can say on any shift and on any day this location can hold x amount of customers. In the example below the max would be 3 at location A. If I can do this in a Measure that would be preferred. Any help is greatly appreciated.