Which statement best explains why design rules help prevent manufacturing defects in PCB production?
Think about how spacing affects electrical connections and shorts.
Design rules specify minimum spacing and sizes to prevent shorts and ensure reliable connections, reducing defects.
Given a dataset with PCB units and a column indicating if design rules were followed (Yes/No), which DAX measure correctly calculates the defect rate only for units that violated design rules?
Defect Rate = DIVIDE(CALCULATE(COUNTROWS(PCBs), PCBs[Defect] = "Yes", PCBs[DesignRuleFollowed] = "No"), CALCULATE(COUNTROWS(PCBs), PCBs[DesignRuleFollowed] = "No"))
Focus on filtering only units that violated design rules for both numerator and denominator.
Option B correctly filters PCBs that violated design rules for both defect count and total count, then divides to get defect rate.
You want to show how defect counts change over months for PCBs that violated design rules versus those that did not. Which visualization is best?
Think about how to show trends over time with categories.
A line chart with separate lines for compliance and violation clearly shows defect trends over time for each group.
Given this DAX measure to count PCBs violating design rules:Violation Count = COUNTROWS(FILTER(PCBs, PCBs[DesignRuleFollowed] = No))
What is the error?
Check how text values are referenced in DAX filters.
Text values must be in quotes. Without quotes, No is treated as a variable causing a syntax error.
A PCB manufacturer wants to reduce defects by tightening design rules but also keep costs low. Which approach best balances defect reduction and cost?
Think about using data to focus efforts where they matter most.
Adjusting design rules based on defect data targets problem areas efficiently, balancing quality and cost.
