Creating some Kpi counting occurence in a given period

[elassus]

Hello everyone and thank you for all your help.  I'm looking a way to better analyze data to improve a service.
Each time users use the service, a line is created (Pls see example below) with columns including date;email;RefenreceId;status 

I would like to create two KPIs.
1) How many users (email) have to make more than 5 attempts with the same ReferenceId in a week before a success?
2) How many Users have made more than 5 Failed attempts with the same ReferenceId before leaving the service?
3) Then I'd like to know, perhaps with a donut chart, the % of successes and failures. For example :

from 1 to 5 successful attempts
from 5-10 attempts with success
from 10 to 20
And The same with Failed.
I'm struggling to find out how to apprehend this type of KPI.
A help would be most welcome.

For example :
2023:06:28 21:01:08 | mail1@domain.com | ReferenceId | success
2023:06:28 21:01:05 | mail1@domain.com | ReferenceId | failed
2023:06:28 21:01:00 | mail1@domain.com | ReferenceId failed
2023:06:28 21:00:55 | mail1@domain.com | ReferenceId failed
2023:06:28 21:01:08 | mail2@domain.com | ReferenceId failed
2023:06:28 21:01:08 | mail2@domain.com | ReferenceId failed
2023:06:28 21:01:08 | mail2@domain.com | ReferenceId failed

[Idrissshatila]

Hello @elassus ,

You could use grouping and Bins to create the 1-5, 5-10, 10-20.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[elassus]

Thank you. Sorry, it is still confuse to me how to create those KPI using group/bins. any light woul be very appreciated