Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 than or equal to 120 divided by the total number of calls processed
My queries are under SQL and I have data:
Call processed - WaitingTime
Can you help me make this request or this measure because I can't insert this condition.
thank you in advance
Solved! Go to Solution.
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 )
Hi @Milozebre,
This sounds achievable, but for us to build a measure as close as possible to your needs, can you please post a sample set of data.
Good Morning Phil,
Thank you for your reply.
Here is the begining of the measure : Mesure 2 = SUM('ACD - APPEL'[AppelTraite]) / SUM('ACD - APPEL'[AppelTraite])
But i want to do : sum of all appel traite where ('ACD - APPEL'[DureeAttente]) is <= 120 divided by the total of ACD - APPEL'[AppelTraite])
Here's something to get you going...
Mesure 2 = DIVIDE ( CALCULATE ( SUM ( 'ACD - APPEL'[AppelTraite] ), FILTER ( ALL ( 'ACD - APPEL' ), 'ACD - APPEL'[DureeAttente] <= 120 ) ), CALCULATE ( SUM ( 'ACD - APPEL'[AppelTraite] ), ALL ( 'ACD - APPEL' ) ), 0 )
Here its 10:27 am 🙂
thank you Sean for your help but when I try your measure, i get a number 93% and when I put time filter on the visual element : it stay a 93%
I try several dates and same result 😞
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 )
Hey @Milozebre I'm not sure about your Text requirement - but yes basically put the "TEXT" value in quotes
Take a look here
http://www.sqlbi.com/articles/filter-arguments-in-calculate/
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |