Forum Discussion
SLA calculation
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 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?
Hi,
Tnx for your help. I took some print screens of the data:
jopper1988 you mean like this?
AcceptedQueuetime<20 = calculate(countrows(table), queuetime < 20)
Accepted = sum(Accepted)
missed= sum(Missed)
SLA = divide(AcceptedQueuetime <20, (accepted + missed))
If i use the code i get a error that the syntax is incorrect.
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