Forum Discussion

jopper1988's avatar
jopper1988
Frequent Visitor
9 years ago
Solved

SLA calculation

Hi,    I'm making a dashboard for our numbers of the telephone. What i want to do is the following:   Calculate a SLA between Accepted < 20 seconds and Missed Calls.    This is the formula that...
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    jopper1988 you mean like this?

    AcceptedQueuetime<20 = calculate(countrows(table), queuetime < 20)

    Accepted = sum(Accepted)

    missed= sum(Missed)

     

    SLA = divide(AcceptedQueuetime <20, (accepted + missed))

     

     

jopper1988's avatar
jopper1988
Frequent Visitor
9 years ago

If i use the code i get a error that the syntax is incorrect. 

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

jopper1988 yes but you can't just paste it all in, if you are learning power bi from scratch the onus is on you to get the basic understanding of how it works.

 

each of those are separate measure which you need to create separately.

 

please refer to these guided learning videos to get the required basic knowledge to use power bi

 

https://powerbi.microsoft.com/en-us/guided-learning/

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    jopper1988 

     

    you could paste this code in, but as i said in the last post, best to get up to speed on your power bi knowledge

     

     

    SLA =
    VAR AcceptedQueuetime20 =
        CALCULATE ( COUNTROWS ( table ), queuetime < 20 )
    VAR Accepted =
        SUM ( table[Accepted] )
    VAR missed =
        SUM ( table[Missed] )
    RETURN
        DIVIDE ( AcceptedQueuetime < 20, ( accepted + missed ) )