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 one day.
Could anyone offer any guidence?
Ticket number/Status/Received datetime/completed datetime/minutes/sameday y/n.
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,
4 Replies
Hi Sbaf
Could you paste some simplified sample data and your expected output here? For further,please refer to
How to Get Your Question Answered Quickly
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,