Forum Discussion
Solved
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 ...
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 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.
parry2k thanks for your time on help me out to solve my problem.