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

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.

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

        I am lost in that PBI file.  Why are there so many visuals there.  Clearly just show one Table visual and show the expected result via a text box explanation.