SLA calculation

[jopper1988]

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 is used in the report tool:

SLA = [Accepted Queuetime < 20] / ([Accepted]+[Missed])

how can i use this in PowerBI

[vanessafvg]

@jopper1988 little bit difficult to conceptualise this without seeing your data?

in order to understand the underlying base measures in your calculation can you post screen shots of your data, is this at a row level or at a summarized level?

can you also give defitnions for accepted queuetime, accepted, missed etc?

[jopper1988]

Hi, 

Tnx for your help. I took some print screens of the data:

[vanessafvg · Accepted solution]

@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]

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

[vanessafvg]

@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]

@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 ) )