cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Milozebre
Helper V
Helper V

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

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

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
)

View solution in original post

7 REPLIES 7
Phil_Seamark
Microsoft
Microsoft

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.

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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

 

 

Sean
Community Champion
Community Champion

Here's something to get you going... Smiley Happy

 

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 😞

 

 

Sean
Community Champion
Community Champion

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
Community Champion
Community Champion

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.

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors