Geometric relations (horizontal, vertical, coincident, tangent) in Solidworks - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Identify the correct geometric relation for horizontal alignment

In a SolidWorks sketch, you want to ensure two lines are perfectly flat and aligned from left to right. Which geometric relation should you apply?

A Horizontal

B Coincident

C Tangent

D Vertical

💡 Hint

Think about the direction that is flat and level.

Horizontal relation makes lines flat and aligned left to right, ensuring no tilt.

❓ dax_lod_result

intermediate

Calculate count of tangent relations in a sketch

You have a dataset of geometric relations in sketches with a column 'RelationType'. Write a DAX measure to count how many 'Tangent' relations exist.

Solidworks

TangentCount = CALCULATE(COUNTROWS(Relations), Relations[RelationType] = "Tangent")

A TangentCount = COUNTROWS(FILTER(Relations, Relations[RelationType] = "Tangent"))

B TangentCount = CALCULATE(COUNTROWS(Relations), Relations[RelationType] = "Tangent")

C TangentCount = SUMX(Relations, IF(Relations[RelationType] = "Tangent", 1, 0))

D TangentCount = COUNT(Relations[RelationType] = "Tangent")

💡 Hint

Use CALCULATE with a filter condition for exact count.

Option B correctly uses CALCULATE with a filter condition to count rows where RelationType is 'Tangent'.

❓ visualization

advanced

Best visualization to show counts of different geometric relations

You want to create a dashboard showing counts of horizontal, vertical, coincident, and tangent relations in sketches. Which visualization type best helps compare these counts clearly?

A Line chart showing counts over time

B Pie chart showing percentage of each relation type

C Stacked bar chart with counts of each relation type per sketch

D Scatter plot with relation types on axes

💡 Hint

Think about comparing counts side by side for categories.

A stacked bar chart clearly compares counts of relation types across sketches, showing totals and breakdowns.

🔧 Formula Fix

advanced

Identify error in DAX measure for coincident relations count

Given this DAX measure:
CoincidentCount = COUNTROWS(FILTER(Relations, Relations[RelationType] == "Coincident"))
What error will occur when running this?

A SyntaxError due to use of '==' instead of '='

B No error, measure runs correctly

C TypeError because COUNTROWS cannot take FILTER

D Runtime error due to missing CALCULATE

💡 Hint

Check the operator used for comparison in DAX.

DAX uses single '=' for comparison, '==' causes syntax error.

🎯 Scenario

expert

Modeling geometric relations data for efficient BI reporting

You have a large dataset of sketches with multiple geometric relations per sketch. You want to build a data model to quickly report counts of each relation type per sketch and overall. Which approach is best?

A Create separate tables for each relation type and join them by SketchID

B Store relations as JSON strings in one column and parse in reports

C Use a single table with one row per sketch and columns for counts of each relation type

D Store all relations in one flat table with SketchID and RelationType columns, then use DAX measures to aggregate

💡 Hint

Think about flexibility and ease of aggregation in BI tools.

A flat table with one row per relation and columns for SketchID and RelationType allows easy filtering and aggregation with DAX.