Forum Discussion

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
9 years ago
Solved

Condition in a measure

Hello, I have a question because I block to make an indicator. I have to calculate a service level indicator. Here is what I would like to do: add all calls processed whose waiting time is less th...
  • Sean's avatar
    Sean
    9 years ago

    Okay try this instead

    Mesure 2 =
DIVIDE (
    CALCULATE (
        SUM ( 'ACD - APPEL'[AppelTraite] ),
        FILTER ( ALLSELECTED ( 'ACD - APPEL' ), 'ACD - APPEL'[DureeAttente] <= 120 )
    ),
    CALCULATE ( SUM ( 'ACD - APPEL'[AppelTraite] ), ALLSELECTED ( 'ACD - APPEL' ) ),
    0
)
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Okay try this instead

Mesure 2 =
DIVIDE (
    CALCULATE (
        SUM ( 'ACD - APPEL'[AppelTraite] ),
        FILTER ( ALLSELECTED ( 'ACD - APPEL' ), 'ACD - APPEL'[DureeAttente] <= 120 )
    ),
    CALCULATE ( SUM ( 'ACD - APPEL'[AppelTraite] ), ALLSELECTED ( 'ACD - APPEL' ) ),
    0
)
Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
9 years ago

Good evening here 11:23 pm 16/03 :)

 

I'm sorry for the late reply. Many thanks to you for your help. It works. In view of the answer, I would never have found it. :)

 

Thank you from Belgium.