topic Re: Calculate % of response times in DAX Commands and Tips

Calculate % of response times

cj1986cj — Thu, 29 Aug 2024 10:30:53 GMT

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%

Re: Calculate % of response times

cj1986cj — Thu, 29 Aug 2024 10:32:34 GMT

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

Re: Calculate % of response times

ahadkarimi — Thu, 29 Aug 2024 14:23:52 GMT

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!

Re: Calculate % of response times

Anonymous — Fri, 30 Aug 2024 05:39:36 GMT

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.