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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Show the expected result very very clearly.

  • 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.