Forum Discussion

ayoubb's avatar
ayoubb
Icon for Helper IV rankHelper IV
6 years ago
Solved

calls ring less than 1min

Please i want to calculate how many calls ring less than 1min  
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    @ayoubb, Try a new column as a

    nueva columna: if([ring duration] <time(0,1,0),1,0)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

@ayoubb, Try a new column as a

nueva columna: if([ring duration] <time(0,1,0),1,0)

  • ayoubb's avatar
    ayoubb
    Icon for Helper IV rankHelper IV
    6 years ago

    IS THIS DAX CORRECT:

     

    Calls less 1>MIN = CALCULATE(COUNT(BENZ[False attempt?]), 'BENZ'[False attempt?] IN {"NO"},"BENZ"[Ring duration]<time(0,1,0),1,0)
    • v-xicai's avatar
      v-xicai
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi ayoubb ,

       

      You may change your formula like DAX below.

       

      Calls less 1>MIN =
CALCULATE (
    COUNT ( 'BENZ'[False attempt?] ),
    FILTER (
        'BENZ',
        'BENZ'[False attempt?] = "NO"
            && 'BENZ'[Ring duration] < TIME ( 0, 1, 0 )
    )
)

      Best Regards,

      Amy 

       

      Community Support Team _ Amy

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