Forum Discussion

Amos_Lim's avatar
Amos_Lim
Icon for Resolver I rankResolver 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
Icon for Resolver I rankResolver I
2 years ago

Below is the expected results.

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Assuming Total Defect and Total Mileage are measures that you have already written, write this measure

Measure = divide([Total defect],[Total mileage])*10000

  • Amos_Lim's avatar
    Amos_Lim
    Icon for Resolver I rankResolver I
    2 years ago

    I have a measure for total fault (first measure in post 1), but I don't have one for total mileage because my mileage table breaks it down by bike and year/month kilometers.

     

    That is why I am utilizing the second measure to total the mileage based on the bike.

     

    If I want to see the breakdown details, I will be able to select the slicers for year/quarter/bike number from my Dashboard.

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      I'll need to see the file to offer any help.