Forum Discussion
Amos_Lim
Resolver I
Resolver IMeasure 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...
Hi,
PBI file attached.
Hope this helps.
Amos_LimResolver I
Resolver IThe "ALLEXCEPT" in
Defect Rate per bike = [Total Defect By Bike No] / CALCULATE(SUM(Mileage[Mileage]), ALLEXCEPT(Mileage, Mileage[Bike]))*100000
may have summed up all the bikes except the slected bike; how can it be reversed? i.e., only the bike in the slicer was selected to sum up the mileage.