Forum Discussion

Amos_Lim's avatar
Amos_Lim
Resolver I
2 years ago
Solved

Measure to Calculate the Defect Rate Not Obtaining the Correct Answer

I created two measures and used them to calculate the failure rate per 100,000 but did not receive the desired result.   The first measure was used to calculate the overall number of defects depend...
Need Help
Show and Tell
Amos_Lim's avatar
Amos_Lim
Resolver I
2 years ago

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 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

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

  • Amos_Lim's avatar
    Amos_Lim
    Resolver I
    2 years ago

    Thanks, Ashish_Mathur.

     

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

  • Amos_Lim's avatar
    Amos_Lim
    Resolver I
    2 years ago

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

  • Amos_Lim's avatar
    Amos_Lim
    Resolver I
    2 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    You are welcome.