Forum Discussion

JLGreen2004's avatar
JLGreen2004
Regular Visitor
3 years ago
Solved

Needing Service Level Run Rate Calculator

Looking to create a Run Rate document that will allow for me to see what service level is needed for the remaining days of the month to meet or stay within SL goal of 80% or higher. 

 

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi JLGreen2004 ,

    According to your description, you want to get the estimated value of EoD Service Level for the blank rows, to keep the average value EoD Service Level in this month stay 80 or higher. Here's my solution.

    Create a measure:

    Measure =
DIVIDE (
    80 * COUNT ( 'Table'[Date] )
        - SUM ( 'Table'[EoD Service Level] ),
    COUNTROWS ( FILTER ( 'Table', 'Table'[EoD Service Level] = BLANK () ) )
)

    The result is 72.57, means estimated value is 72.57.

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi JLGreen2004 ,

    According to your description, you want to get the estimated value of EoD Service Level for the blank rows, to keep the average value EoD Service Level in this month stay 80 or higher. Here's my solution.

    Create a measure:

    Measure =
DIVIDE (
    80 * COUNT ( 'Table'[Date] )
        - SUM ( 'Table'[EoD Service Level] ),
    COUNTROWS ( FILTER ( 'Table', 'Table'[EoD Service Level] = BLANK () ) )
)

    The result is 72.57, means estimated value is 72.57.

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.