Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 and PPK values do not. I would appreciate any assistance in verifying my formulas or guidance towards resolving this discrepancy. Any insights or suggestions to ensure consistent results across both Power BI and Minitab are greatly appreciated.
Here are the formulas I've been using for creating new measures:
PowerBI results:
Minitab results:
Link to minitabs calculation for PPK: https://blog.minitab.com/en/how-cpk-and-ppk-are-calculated2c-part-1
Solved! Go to Solution.
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:
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:
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.
I just used the clustered column chart built into PowerBI
To add the X-Axis constant lines:
Hi @caballerov ,
From the screenshots you provided, it seems that the Sample Mean values on the two screenshots are also different.
Below is the data I created based on the information you provided.
Then I used the formula you mentioned. Result is as below.
Have you made the following changes to your Measure?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and assist you.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Yulia,
I updated the value to reflect more decimal points:
Sample Mean Formula:
And yes I did try adding more decimal points to the PPK measure as well:
I would love to share the data but its company sensitive. Is there anything you could reccomend looking at?
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |