Calculated Fields and LODs Flashcards

Which LOD expression computes a value at a coarser level of detail than the view, ignoring the dimensions in the view except those listed?

Answer: FIXED

FIXED computes a value using only the specified dimensions, regardless of any other dimensions in the view.

In the order of operations, where do FIXED LOD expressions get evaluated relative to dimension filters?

Answer: Before dimension filters

FIXED LODs are computed before dimension filters are applied, so those filters do not affect them unless added to context.

Which function would you use to convert a string '2026-01-15' into a date value in a calculated field?

Answer: DATEPARSE or DATE

DATE() or DATEPARSE() converts string input into a proper date data type.

What does the calculated field SUM([Sales]) / SUM([Profit]) produce compared to AVG([Sales]/[Profit])?

Answer: An aggregate ratio of totals vs. an average of row ratios

SUM/SUM aggregates first then divides, while AVG of row ratios averages each row's ratio—usually different values.

Which keyword makes an INCLUDE LOD differ from the view's grain?

Answer: It adds dimensions into the calculation not present in the view

INCLUDE computes at a finer grain by adding the listed dimensions, then aggregates up to the view level.

What is the result type of the expression IIF([Sales] > 1000, 'High', 'Low')?

Answer: String

IIF returns the second or third argument here, both strings, so the result is a string.

Why might a FIXED LOD ignore a quick filter on a dashboard?

Answer: FIXED is computed before dimension filters unless they are in context

Because FIXED runs before dimension filters, those filters must be added to context to influence the FIXED result.