You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains a measure group named Sales and a dimension named Products. The Products dimension contains an attribute named Product

The SCOPE statement in an MDX script lets you define a precise subcube - for example, the intersection of [Products].[Product Category].[Clothing] and [Measures].[ProductCategoryDiscount] - and then assign a calculation (THIS = [Measures].[Sales Amount] * 0.1) within that scope. This cleanly isolates the 10 percent discount calculation so it applies only to the Clothing category, exactly matching the requirement.

IIF is a conditional expression used inline within a single MDX expression; it requires explicitly testing a condition on every evaluation and is less clean for applying a calculation across an entire category slice than a SCOPE assignment.

Filter returns a subset of a set where a condition is true; it is used to narrow down sets for queries, not to define and assign calculated values scoped to a dimension member.

CurrentMember returns the current member being iterated in an MDX expression; it is a helper function used inside expressions and does not by itself define a scoped calculation for a specific category.

IsLeaf tests whether the current member is a leaf-level member in a hierarchy; it is used for conditional logic in parent-child hierarchies and is unrelated to scoping a calculation to a specific category.

The Drillthrough statement is used to retrieve the underlying detail rows from the fact table for a cell value; it is an action type, not a mechanism for defining calculated member logic.