Forum Discussion
Solved
KPI for same day close
Hello, I'm new to power bi and have data for a ticket system in the following format. I'm struggling to create a KPI for same day close which has a target of 75% of all tickets received in any o...
Hi Sbaf
Please check if below measure could help.It gives the KPI of same day and closed ticket.For example: (40%=2/5)
Measure = COUNTROWS ( FILTER ( Data, Data[SameDay] = "yes" && Data[Status] = "Closed" ) ) / COUNTROWS ( Data )Regards,
Hello, Thank you for the link that's most useful! Here is a sample of the data I'm using. I'm aiming for a KPI that will have a target of 75% of total tickets received that are closed on the same day. Using a measure for same day count- Measure 2 = CALCULATE ( COUNTROWS ( 'data'), FILTER ( 'data', 'data'[SameDay] = "yes" ) ) / COUNTROWS ( 'data' ) I'm struggling with getting the target in- newbie problems.- :| Ticket Number Account CurrentStatus Receiveddate Completeddate MINUTES SameDay 001-00-161513 Comp A Closed 01/01/2019 08:30 25/01/2019 09:04 190 No 001-00-161514 Comp B Closed 01/01/2019 10:42 02/01/2019 10:45 15 No 001-00-161515 Comp C Closed 01/01/2019 19:38 02/01/2019 09:56 30 Yes 001-00-161516 Comp D Closed 02/01/2019 07:41 02/01/2019 09:07 10 Yes 001-00-161517 Comp E Closed 02/01/2019 08:13 02/01/2019 15:38 45 Yes
Hi Sbaf
Please check if below measure could help.It gives the KPI of same day and closed ticket.For example: (40%=2/5)
Measure =
COUNTROWS ( FILTER ( Data, Data[SameDay] = "yes" && Data[Status] = "Closed" ) )
/ COUNTROWS ( Data )
Regards,
Thank you! That's given me what I need :)