Calculate % of response times

[cj1986cj]

Hi All

New user here, hoping you guys can help.

My company have a response time for phone calls of 90 minutes, within power BI i simply want to show what % of calls we reply to within 90 minutes, example table below from my report. So the origin would need to be Phone or Indirect Information.   so of the 8 calls below, 7 were responded to on time therefore an on time response time % of 87.50%

[ahadkarimi · Accepted solution]

Hi @cj1986cj, give this a try, and if you encounter any issues, let me know.

OnTimeResponseTime% =
DIVIDE(
    CALCULATE(
        COUNTROWS(Sheet1),
        Sheet1[Sum of Response Time in Minutes] <= 90,
        Sheet1[Origin] IN {"Phone", "Indirect Information"}
    ),
    CALCULATE(
        COUNTROWS(Sheet1),
        Sheet1[Origin] IN {"Phone", "Indirect Information"}
    )
) * 100

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!

[Anonymous · Accepted solution]

Hi All
Firstly  ahadkarimi thank you for your solution!
And @cj1986cj, you can try the following code which may help your problem.

Measure = 
VAR A=MAXX('Table',CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Response Time in Minutes]<=90)))
VAR B=CALCULATE(COUNTROWS('Table'),ALL('Table'))
RETURN
DIVIDE(A,B,0)

I hope my solution solves your problem, and I would be immensely proud if it helps you!
Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[cj1986cj]

Maybe worth noting the formula that AI gave me (that doesnt work) 

On Time Response Time % =

DIVIDE(

    CALCULATE(

        COUNTROWS(Sheet1),

        Sheet1[Response Time in Minutes] <= 90,

        Sheet1[Origin] IN {"Phone", "Indirect Information"}

    ),

    CALCULATE(

        COUNTROWS(Sheet1),

        Sheet1[Origin] IN {"Phone", "Indirect Information"}

    )

) * 100

[ahadkarimi · Accepted solution]

Hi @cj1986cj, give this a try, and if you encounter any issues, let me know.

OnTimeResponseTime% =
DIVIDE(
    CALCULATE(
        COUNTROWS(Sheet1),
        Sheet1[Sum of Response Time in Minutes] <= 90,
        Sheet1[Origin] IN {"Phone", "Indirect Information"}
    ),
    CALCULATE(
        COUNTROWS(Sheet1),
        Sheet1[Origin] IN {"Phone", "Indirect Information"}
    )
) * 100

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!