Calculate DPMO

[Lu1sT0rr3s]

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

[parry2k]

@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

[Lu1sT0rr3s]

@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

[Lu1sT0rr3s]

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.

[parry2k]

@Lu1sT0rr3s does this make sense based on sample data your provided

[Lu1sT0rr3s]

@parry2k It will be possible group by line? It work for me except that I need by line.

can you please explain me how do you calculate the DPMO because really your formula works.

[parry2k · Accepted solution]

@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]

@parry2k thanks for your time on help me out to solve my problem.