cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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?

1 ACCEPTED SOLUTION
Super User

@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

`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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

7 REPLIES 7
Super User

@Lu1sT0rr3s you have to share sample dataset to mkae it work. i don't know what you tried and why it not worked.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

@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

Frequent Visitor

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.

Super User

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

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

Super User

@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

`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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.