Calls occur simultaneously in the same period of time

[Sergio_Rocha]

Hello.
I have a problem and I don't know how to solve it.
We have a table with different groups of telephone calls, a call center. I want to know how many Calls occur simultaneously in the same period of time, according to the filtered period. The ones where the start time and end time are within the same time window, returning these quantities, and allowing you to filter them.
Thanks a lot for the help.

	Hora Inicio	Hora fim	Duracao	Origem	Destino	Recurso
07/08/2021	10:11:00	10:11:00	00:00:00	Externo	Ramal 301	Fila 1
07/08/2021	10:11:00	10:11:37	00:00:37	Externo	Ramal 300	Fila 1
07/08/2021	10:11:00	10:11:39	00:00:39	Externo	Ramal 300	Fila 2
07/08/2021	10:13:00	10:13:25	00:00:25	Externo	Ramal 301	Fila 2
07/08/2021	10:15:00	10:16:17	00:01:17	Externo	Ramal 300	Fila 2
07/08/2021	10:16:00	10:17:02	00:01:02	Ramal 211	Externo	Fila 1
07/08/2021	10:17:00	10:17:00	00:00:00	Ramal 212	Externo	Fila 1
07/08/2021	10:18:00	10:18:30	00:00:30	Ramal 213	Externo	Fila 2
07/08/2021	10:19:00	10:19:00	00:00:00	Ramal 214	Externo	Fila 3

[VahidDM]

Hi @Sergio_Rocha 

Try this measure:

Calls occur = 
VAR _Inicio =
    MIN ( 'Table'[Hora Inicio] )
VAR _fim =
    MAX ( 'Table'[ Hora fim] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Hora Inicio] >= _Inicio
                && 'Table'[ Hora fim] <= _fim
        )
    )

Output:

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

Appreciate your Kudos✌️!!

[Sergio_Rocha]

Thank you so much for your help Vahid.

I tested the Measure and it worked very well !!! Congratulations and Thank you...

But Vahid's intention is to know within a period, how many connections occurred simultaneously... But why is this information Important? What is the application? As it is a CallCenter, the idea is to identify if there is a need to increase the number of channels. By identifying the occupancy rate in specific periods (Simultaneous Calls) we can identify whether there is a need to increase channels.

[Greg_Deckler]

@Sergio_Rocha 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[Sergio_Rocha]

Thanks Greg,
I was confused to understand some of the dax codes you used.
Please could you help me with something simpler, maybe using my template?