Measure to Calculate the Defect Rate Not Obtaining the Correct Answer

There were only two charts I intended to display.

The first one was the defect rate by bike number.

The second one was the defect rate per subsystem.

I removed the checker page since I use it to analyze my results.

For the first chart, for e.g. bike 115 should have the result of 60.467 instead of 8.0178. (refer to message 4)

For the second chart, e.g. subsystem AATS in year 2022 & 2023 total defect was 32 & 27.

and the total mileage (all bikes included) for year 2022 & 2023 was 718051 & 666353.

Hence, the defect rate should be 0.4456 (2022 AATS defect / 2022 total mileage *100000) & 0.4051 (2023 AATS defect / 2023 total mileage *100000) but I am getting the result as in the chart  0.4333 & 0.5056.

Sample2 Power BI 

Hi,

Both those tables are coming from an MS Excel file.  Share the download link of that Excel file.

Excel file as follow:-

Sample Excel File 

Thanks, Ashish_Mathur.

I saw you added an additional table called bike. Could you possibly share the Excel file with me as well?

Okay. I saw it was just the bike number. Thanks.

Thank you for your time and effort in assisting me. Thanks.

You are welcome.