Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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,
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,
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 🙂