What type of field would display the average value of homes in the United States for the calendar year 2020?

Question

Options

• AA discrete date part dimension
• BA continuous date value dimension
• CA geographical dimension
• DAn aggregated measure

• A
  3% (1)
• B
  11% (4)
• C
  5% (2)
• D
  82% (31)

Explanation

Option D is correct because "average value of homes" is a numerical calculation performed across multiple records - that's the definition of an aggregated measure. Measures are quantitative fields that can be aggregated (summed, averaged, counted), and displaying an average is explicitly an aggregation operation.

Why the distractors are wrong:

• A & B (date dimensions): These describe how time is represented on an axis - either as discrete buckets (e.g., "Q1, Q2") or a continuous timeline. Neither performs or displays a numerical calculation.
• C (geographical dimension): This categorizes data by location (state, country, zip code). Geography tells you where, not what the numeric value is.

Memory tip: If a field calculates something (sum, average, count, min, max), it's a measure. If it categorizes or labels something (date, place, name), it's a dimension. The word "average" in the question is your signal - aggregation = measure.

No community discussion yet for this question.