I am very new to Power BI (less than 5 hours) and am using it to identify ideal process settings for a piece of equipment on one of our production lines. For the current piece of equipment I am working on, we have one of three outcomes, that loosely translate to good, bad or marginal product quality.
What I did was split the process settings into bins (in hopes of finding the ideal operating window), and using a column which quantifies product quality, create three individual calculated columns which output a 1 or 0 based on an if statment of whether or not the quality conditions were met so they could be summed later for a count. I also created a Total column summing all three so I would know the total number of instances that fell within that specific process settings range (in this case 5 psi ranges). I then created a visualization table summing all instances of the three columns within the process settings range and it appears to have worked well, but the one thing I cannot figure out how to do is perform calculations within that table (ex. there were 45,000 good, 3,000 marginal and 1,500 bad in settings window 1, so the yield of "good" product was 90.9%).
For instace, I would like to be able to identify the percentage that fall into each of the three groups and cannot find a way to do this. Calculated columns do not appear to help given my understanding of them since they're based off the individual rows of data and not the set or bin as a whole. Any insight into any type of automatically updating calculation I could perform on each window/row on the table would be greatly appreciated.
Thanks,
Nick
