Forum Discussion
Calculate DPMO
Lu1sT0rr3s yes you can group by anything. here are steps, some of these can be merged but I like it seperate, easy to work/debug with
Add new column for defects
Defect = Defect[Class0] + Defect[Class1] + Defect[Class2] + Defect[Class3]
Add new measures for DPMO calculation
Total Defect = SUM( Defect[Defect] ) Total Sample = SUM( Defect[sample] ) DPMO = DIVIDE( ([Total Defect]*1000000), [Total Sample])
You can group it by any field in your table and it will work.
Lu1sT0rr3s you have to share sample dataset to mkae it work. i don't know what you tried and why it not worked.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
parry2k Look, this is a part of my data set:
Product Line Line Qty sample Class0 Class1 Class2 Class3 AQR Prox RH LINEA 11 1920 100 0 5 3 1 AQR Prox RH LINEA 11 1920 100 0 8 1 3 AQR Prox RH LINEA 11 1920 99 0 2 2 0 AQR Echelon Flex 45 LINEA 120 461 20 0 1 2 1 AQR Echelon Flex 60 LINEA 96 701 32 0 1 2 1 AQR Proximate LINEA 12 13440 125 0 25 4 29 AQR Proximate LINEA 12 13440 125 0 26 3 8 AQR Proximate LINEA 12 14400 125 0 36 11 25 AQR Prox RH LINEA 11 8640 80 0 3 1 0 What I do for this was create a new column to sum all defects and this works for my porpuse:
Then I start to write the formula to calculate the DPMO rate:
so, the result is the following:The defects and samples are corrects and totally works for me but the DPMO is not working.
