Forum Discussion

caballerov's avatar
caballerov
Regular Visitor
2 years ago
Solved

Calculating PPK values in PowerBI vs Minitab - Need help.

I am encountering inconsistencies between Power BI and Minitab when calculating the PPK value, despite using the identical data set. While the PPL value calculations align in both software, the PPU a...
Need Help
Show and Tell
Tips and Tricks
  • caballerov's avatar
    caballerov
    2 years ago

    For anyone trying to figure this out, I was able to get the same PPK result as Minitab by calculating the Sigma and Mean values by filtering the data within the limits.

     

    I created new Measures for both:

    Sigma Within Limits =
    CALCULATE(
        STDEV.S(Data[Net(g)]),
        FILTER(
            Data,
            Data[Net(g)] >= LSL[LSL Value] &&
            Data[Net(g)] <= USL[USL Value]
        )
    )
     
    Mean Within Limits =
    AVERAGEX(
        FILTER(
            Data,
            Data[Net(g)] >= LSL[LSL Value] &&
            Data[Net(g)] <= USL[USL Value]
        ),
        Data[Net(g)]
    )
     
    PPU Within Limits = (USL[USL Value] - [Mean Within Limits]) / (3 * [Sigma Within Limits])
    PPL Within Limits = ([Mean Within Limits] - LSL[LSL Value]) / (3 * [Sigma Within Limits])
     
    PPK Within Limits = MIN([PPU Within Limits], [PPL Within Limits])
TomasRajnak's avatar
TomasRajnak
New Member
2 years ago

Hello, please how did you make such a nice histogram in PowerBI?
Is there some tutorial you have used?
I saw many tutorials on youtube, but this your example seems most appropriate for me.
Many thanks.

  • caballerov's avatar
    caballerov
    Regular Visitor
    2 years ago

    I just used the clustered column chart built into PowerBI

     

    To add the X-Axis constant lines: