Think about how you clean up a drawing by cutting off extra parts.
The Sketch Trim tool is used to remove unwanted parts of sketch lines or curves by trimming them at intersections or boundaries.
Think about cutting versus stretching lines.
Trim cuts away parts of sketch entities, while Extend lengthens them to meet other sketch entities.
Use FILTER inside SUMX to sum only trimmed lines.
SUMX with FILTER correctly sums lengths of lines where IsTrimmed is TRUE. CALCULATE with a filter expression requires FILTER function for row context.
Think about comparing two categories across projects.
A stacked bar chart clearly shows the counts of each tool's usage per project side by side, making comparison easy.
TotalExtendedLength = CALCULATE(SUM(SketchLines[Length]), SketchLines[IsExtended] = TRUE)This measure returns an error. What is the cause?
TotalExtendedLength = CALCULATE(SUM(SketchLines[Length]), SketchLines[IsExtended] = TRUE)
CALCULATE requires filter expressions to be valid Boolean filters or wrapped in FILTER.
Using 'SketchLines[IsExtended] = TRUE' directly inside CALCULATE causes an error because it is not a valid filter expression. Wrapping it inside FILTER creates the proper row context.