Need Help Calculate the percentage

[Anonymous]

Hi, I need help to find out the % of first time connect.  I have a data set and below is the sample.

It is the log to show the connect to the wireless display device in different meeting room.

there are couple situation show the connection status:

1) Senario 1, If connect successful you will see event code 201-->202 and if user disconnect properly it will show 304 with the set.  so in this senario from connect--> sucessful connect --> sucessfully disconnect when done meeting 201->202->304

2) Senario 2, 201-->202-->304-->201-->204 in this senario the user successfully connect and some how it got disconnect and when she try again it failed.  So you will see the pattern 201->202->304->201->240

3) Senario 3, 201-->210 or 201--> 240 this is a failed and user never try again

4) Senario 4, 201->220->201->202->304  in this senario user connect and failed and try again and success.

What I want to do is basically want to get the percentage of people in a week time (the data set is a weekly range) how many of them able to connect at fist try.  so if I see the pattern 201->202->304 and no other line within that group.

If I see pattern like senario 4 it is not first time connect success.

Thanks for all your help in advance!

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Please apply the DAX of the following PBIX file to your table, and check if you get expected result.

https://1drv.ms/u/s!AhsotbnGu1NolBRxoLpN1b5OzBkT

Regards,
Lydia