Help with generating a summary table

Hi,Anonymous. Hello,ryan_mayu ,thanks for your concern about this issue.And I would like to share some additional solutions below.
I am glad to help you.

According to your description, you want to count the number of tickets in a selected time period

You could refer to my test result below, hope it can help you.
Here is my test data:

I created two measures to calculate the number of Tickets whose DateIn and DateOut are within the range selected by the slicer.

Here is the Dax code

M_ticketIn = 
VAR minDate=MIN('Dates'[Date])
VAR maxDate=MAX('Dates'[Date])
RETURN
CALCULATE(
    COUNT(SaleTicket[Ticket]),FILTER(ALL(SaleTicket),'SaleTicket'[Date in]>=minDate&&'SaleTicket'[Date in]<=maxDate))

M_ticketOut = 
VAR minDate=MIN('Dates'[Date])
VAR maxDate=MAX('Dates'[Date])
RETURN
CALCULATE(
    COUNT('SaleTicket'[Ticket]),FILTER(ALL('SaleTicket'),'SaleTicket'[Date out]>=minDate&&'SaleTicket'[Date out]<=maxDate))

I've created a measrue M_result that counts the number of Tickets that match both DateIn and DateOut for the selected time period.

i.e. the number of tickects that start and end in the selected time period.

M_result = 
IF('SaleTicket'[M_ticketIn]<='SaleTicket'[M_ticketOut],'SaleTicket'[M_ticketIn],'SaleTicket'[M_ticketOut])

You can also try to use the WeekNum function to get the number of weeks for each date to calculate (this avoids having to set the time period manually).
Here is the test result:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

I cannot understand your expected result of 8 and 10?  Explain that in detail.