KPI for same day close

[Sbaf]

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.

[v-cherch-msft]

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,

[Sbaf]

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

[v-cherch-msft · Accepted solution]

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,

[Sbaf]

Thank you! That's given me what I need 🙂