Calculated Fields and LODs Flashcards

Which scenario is a classic use case for a FIXED LOD?

Answer: Customer cohort analysis by first purchase date

FIXED is ideal for pinning each customer's first purchase date regardless of the view, enabling cohort analysis.

What does CASE [Region] WHEN 'East' THEN 1 ELSE 0 END return for a West row?

Answer: 0

The ELSE branch returns 0 for any region that is not East.

Which is true about COUNTD inside a FIXED LOD versus in the view?

Answer: FIXED COUNTD can give correct distinct counts unaffected by view dimensions

Using COUNTD within a FIXED LOD computes distinct counts at the specified grain independent of the view.

What is the effect of adding a measure filter on a FIXED LOD result?

Answer: Measure filters apply after FIXED is computed, so they can filter the result

Measure filters are applied after LOD computation, so they can filter based on the FIXED value.

Which function rounds 3.7 to 4 in a calculated field?

Answer: ROUND(3.7)

ROUND(3.7) rounds to the nearest integer, giving 4, while INT and FLOOR would give 3.

Why might COUNTD([CustomerID]) at the view level differ from {FIXED : COUNTD([CustomerID])}?

Answer: The view-level count is partitioned by view dimensions; the FIXED is a single total

The view-level COUNTD is split per dimension in the view, while the empty FIXED computes one overall distinct count.

What does the LOD {INCLUDE [Product]: AVG([Sales])} produce when placed in a view by Region?

Answer: Average sales computed per product, then averaged up to region

INCLUDE [Product] computes the average at product grain first, then aggregates to the region level in the view.