Forum Discussion
Calculate DPMO
Hello all, I'm new using Power BI and there is a few things that are not clear enough.
I'm trying to calculate a DPMO rate however when I introduce my formula the result is completly different that what I expect.
The math of the DPMO es easy, just (Total defects*1000000)/samples taken
so, anyone of you could help me on this?
thanks in advance
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.
7 Replies
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/38490parry2k 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.
