Line and centerline tools in Solidworks - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding the purpose of centerlines in technical drawings

Why are centerlines important in technical drawings created with line and centerline tools?

A They show the color coding of different materials.

B They are used to highlight the outer edges of a part.

C They indicate the exact center of circles and symmetrical parts for reference.

D They replace dimension lines to reduce clutter.

💡 Hint

Think about what symmetrical parts need to show clearly in a drawing.

Centerlines mark the center of circles and symmetrical features, helping to locate and align parts accurately.

❓ dax_lod_result

intermediate

Calculating total length of centerlines in a drawing

Given a dataset of line segments with their lengths, which DAX measure correctly calculates the total length of all centerlines?

Solidworks

LinesTable = Table with columns: LineType ("Centerline" or "Regular"), Length (numeric)

A TotalCenterlineLength = CALCULATE(SUM(LinesTable[Length]), LinesTable[LineType] = "Centerline")

B TotalCenterlineLength = CALCULATE(SUM(LinesTable[Length]), FILTER(LinesTable, LinesTable[LineType] = "Centerline"))

C TotalCenterlineLength = SUM(LinesTable[Length])

D TotalCenterlineLength = SUMX(FILTER(LinesTable, LinesTable[LineType] = "Centerline"), LinesTable[Length])

💡 Hint

Remember that CALCULATE with a direct filter condition requires special syntax.

SUMX with FILTER correctly sums lengths only for centerlines. Option D is invalid syntax because CALCULATE needs FILTER for row context filters.

❓ visualization

advanced

Best visualization to show distribution of line types in a drawing

You want to create a dashboard showing the count of different line types (centerline, construction line, regular line) used in multiple drawings. Which visualization is best?

A Pie chart showing percentage of each line type

B Stacked bar chart showing counts of line types per drawing

C Scatter plot with line length on X and line type on Y

D Line chart showing line type counts over time

💡 Hint

Think about comparing counts across multiple drawings and categories.

A stacked bar chart clearly shows counts of each line type per drawing, making comparisons easy. Pie charts are less effective for multiple categories and groups.

🔧 Formula Fix

advanced

Identify the error in this DAX measure for counting centerlines

What error does this DAX measure produce?

CenterlineCount = COUNTROWS(FILTER(LinesTable, LinesTable[LineType] == "Centerline"))

A SyntaxError due to use of '==' instead of '=' in filter condition

B TypeError because COUNTROWS cannot be used with FILTER

C No error, measure returns correct count

D Runtime error due to missing aggregation

💡 Hint

Check the correct operator for equality in DAX filter expressions.

DAX uses a single '=' for equality, not '=='. Using '==' causes a syntax error.

🎯 Scenario

expert

Optimizing a report showing centerline usage across projects

You have a large dataset of drawings with line details. The report shows total centerline length per project. The current DAX measure is slow:

TotalCenterlineLength = SUMX(FILTER(LinesTable, LinesTable[LineType] = "Centerline"), LinesTable[Length])

Which optimization improves performance without changing the result?

A Use CALCULATE with FILTER instead of SUMX:<br>TotalCenterlineLength = CALCULATE(SUM(LinesTable[Length]), FILTER(LinesTable, LinesTable[LineType] = "Centerline"))

B Replace FILTER with ALL to remove filters:<br>TotalCenterlineLength = CALCULATE(SUM(LinesTable[Length]), ALL(LinesTable))

C Create a calculated column with 0 for non-centerlines and length for centerlines, then sum that column.

D Use COUNTROWS instead of SUMX to count centerlines.

💡 Hint

CALCULATE with FILTER can be more efficient than SUMX with FILTER.

Using CALCULATE with FILTER leverages filter context better and improves performance. Option A adds storage cost and complexity. Option A removes filters incorrectly. Option A counts rows, not sums length.