Forum Discussion

virus190's avatar
virus190
Helper II
5 years ago

How many calls at the same time?

Hello,   maybe someone can help, i would appreciate it.   I want to know how many calls were at the same time, i got this data from 1 day:     If i do this manually:     Is this...
Need Help
Icey's avatar
Icey
Community Support
5 years ago

Hi virus190 ,

 

Try this:

column =
VAR _1 = [Accepted]
VAR _2 = [Hang up]
VAR t =
    ADDCOLUMNS (
        FILTER ( 'Table', 'Table'[CALL ID] < EARLIER ( 'Table'[CALL ID] ) ),
        "col",
            IF (
                 ( _1 <= [Accepted]
                    && _2 > [Accepted] )
                    || ( _1 >= [Accepted]
                    && _1 <= [Hang up] ),
                1
            )
    )
RETURN
    IF ( NOT ( ISBLANK ( COUNTROWS ( FILTER ( t, [col] = 1 ) ) ) ), "x" )

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

  • virus190's avatar
    virus190
    Helper II
    5 years ago

    Hello Icey 

     

    it does work, but only with a few rows.

     

    I didnt mention that i have like 1 Mio+ rows and if i use this, it just loads forever.

    Maybe there is another way? Maybe with PowerQuery?

     

    Download PBIX File 

    • Icey's avatar
      Icey
      Community Support
      5 years ago

      Hi virus190 ,

       

      I have no access to your shared file. Please share it publicly. 

      In addition, please remove sensitive information.

       

       

      Best Regards,

      Icey

    • Icey's avatar
      Icey
      Community Support
      5 years ago

      Hi virus190 ,

       

      This is caused by calculation logic. Unavoidable. ☹️ Maybe others 

      In addition, I modify the expression a bit and it will be slightly better.

      Column 2 =
VAR _1 = [Accepted]
VAR _2 = [Hang up]
RETURN
    IF (
        NOT (
            ISEMPTY (
                FILTER (
                    'Table',
                    'Table'[CALL ID] < EARLIER ( 'Table'[CALL ID] )
                        && _2 >= [Accepted]
                        && _1 <= [Hang up]
                )
            )
        ),
        "x"
    )

       

      Or you can try to create a measure:

      Measure =
VAR _1 =
    MAX ( [Accepted] )
VAR _2 =
    MAX ( [Hang up] )
RETURN
    IF (
        NOT (
            ISEMPTY (
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[CALL ID] < MAX ( 'Table'[CALL ID] )
                        && _2 >= [Accepted]
                        && _1 <= [Hang up]
                )
            )
        ),
        "x"
    )

       

       

      Best Regards,

      Icey

       

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

       

      • virus190's avatar
        virus190
        Helper II
        5 years ago

        Oh, i accidently hit the Accept solution button..

         

        Well, for me it didnt work. The first one again, was loading forever. The second gave me everywhere an X.

         

        Maybe it is easier just to get the number of same calls, i dont necessarily need the X, it would be just a way to count them. Is this possible?