Needing Service Level Run Rate Calculator

[JLGreen2004]

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 · Accepted solution]

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.