Forum Discussion
Resolver IMeasure to Calculate the Defect Rate Not Obtaining the Correct Answer
Hi,
PBI file attached.
Hope this helps.
Resolver II 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.
Super UserI'll need to see the file to offer any help.
- Amos_Lim
Thanks, Ashish_Mathur.
I tried the filter, divide but did not receive the desired results.
Power BI Sample File & Excel File
- Ashish_Mathur
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.
- Amos_Lim
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.