Complete the formula to calculate the trace width based on current capacity.
trace_width = current [1] kThe trace width is proportional to the current multiplied by a constant factor k.
Complete the DAX measure to calculate total current capacity from a table named 'Traces'.
TotalCurrent = SUM(Traces[[1]])The measure sums the 'Current' column to get total current capacity.
Fix the error in this SQL query to select trace widths greater than 10 mils.
SELECT * FROM Traces WHERE Width [1] 10
The query filters traces with width greater than 10 mils using the '>' operator.
Fill both blanks to create a dictionary comprehension that maps trace names to widths for traces with current {{BLANK_1}} 5 and width {{BLANK_2}} 10.
{trace['name']: trace['width'] for trace in traces if trace['current'] [1] 5 and trace['width'] [2] 10}The comprehension filters traces with current greater than 5 and width less than 10.
Fill all three blanks to create a DAX measure that calculates average trace width for traces with current {{BLANK_1}} 3, width {{BLANK_2}} 20, and length {{BLANK_3}} 50.
AvgWidth = AVERAGEX(FILTER(Traces, Traces[Current] [1] 3 && Traces[Width] [2] 20 && Traces[Length] [3] 50), Traces[Width])
The measure filters traces with current greater or equal to 3, width less than 20, and length greater than 50, then averages their widths.
