Exam Preparation Quiz

Explanations for each answer:

• [Sales] - [Cogs] is correct. This expression references the existing explicit measures for Sales and Cogs directly. Defining the Margin measure this way ensures flexibility, scalability, and consistency in your model. It also makes maintenance easy if your Sales or Cogs calculations change.
• CALCULATE(SUM(SalesTable[SalesAmount])) - CALCULATE(SUM(SalesTable[CogsAmount])) is incorrect. This expression works for calculating margin but does not reference existing explicit measures. Using SUM directly on columns creates dependencies on raw columns, making the measure less flexible if your calculations for Sales or Cogs become more complex. Also, CALCULATE is unnecessary here if you aren’t modifying filter context.
• SUM(SalesTable[SalesAmount]) - SUM(SalesTable[CogsAmount]) is incorrect. This expression works for calculating margin but does not reference existing explicit measures. Using SUM directly on columns creates dependencies on raw columns, making the measure less flexible if your calculations for Sales or Cogs become more complex.
• SUMX(SalesTable, SalesTable[SalesAmount] - SalesTable[CogsAmount]) is incorrect. SUMX performs row-by-row calculations, which can be useful for certain scenarios (e.g., if unit costs vary per row), but it adds unnecessary complexity if you already have explicit measures. For aggregated sales and cogs, SUMX is not needed.