What is the main purpose of using Geometric Dimensioning and Tolerancing (GD&T) in engineering drawings?
Think about how GD&T helps ensure parts fit and function properly despite manufacturing variations.
GD&T is used to communicate allowable variations in geometry to ensure parts fit and function correctly.
You have a dataset of parts with a column 'FeatureControlFrames' listing the number of GD&T feature control frames per part. Which DAX measure correctly calculates the total number of feature control frames across all parts?
Think about how to add up all the frame counts, not just count rows or unique values.
SUM adds all values in the column, giving the total number of feature control frames.
Which type of visualization best helps analyze the distribution of positional tolerances across multiple parts in a manufacturing report?
Consider how to see individual tolerance values and their status clearly.
A scatter plot allows viewing each part's tolerance value and status distinctly, helping identify outliers.
You have tables for Parts, Features, and Tolerances. Each part has multiple features, and each feature can have multiple tolerances. What is the best way to model these relationships in a BI tool?
Think about how parts contain features, and features contain tolerances.
One-to-many relationships reflect the natural hierarchy and enable efficient filtering and aggregation.
Given this DAX measure to calculate average positional tolerance for features:
AvgPosTol = AVERAGE(Features[PositionalTolerance])
Why might this measure produce incorrect results when used in a report filtered by part?
Check if the data model supports filtering from Parts to Features.
If Features is not related to Parts, filtering by part does not filter features, so average is over all features.
