cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors