Dimensions vs measures concept in Tableau - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Identify the correct definition of a measure in Tableau

In Tableau, which of the following best describes a measure?

A A field that contains text descriptions or labels.

B A field that contains categorical data used to segment or group data.

C A field that stores date and time information only.

D A field that contains numerical data which can be aggregated or used in calculations.

💡 Hint

Measures are usually numbers you can add, average, or count.

Measures in Tableau are numeric fields that can be aggregated, such as sums or averages, to analyze data quantitatively.

🧠 Conceptual

intermediate

Choose the correct example of a dimension in Tableau

Which of the following is an example of a dimension in Tableau?

A Average profit margin percentage.

B Sales amount for each transaction.

C Customer names used to group sales data.

D Total number of products sold.

💡 Hint

Dimensions are used to slice and dice data, often text or categories.

Dimensions are fields like customer names that categorize data and help segment measures.

❓ dax_lod_result

advanced

Determine the output of this Tableau LOD expression

Given a dataset with sales data, what is the result of this Tableau LOD expression?

{ FIXED [Region] : SUM([Sales]) }

Assuming the data has regions 'East' and 'West' with sales 1000 and 2000 respectively, what does this expression return when placed on a view showing all sales rows?

A It returns the total sales for each region repeated on every row belonging to that region (1000 for East rows, 2000 for West rows).

B It returns the grand total sales across all regions (3000) on every row.

C It returns the sum of sales for each individual row only.

D It causes an error because FIXED LOD cannot be used with SUM.

💡 Hint

FIXED LOD calculates aggregation at the specified dimension level.

The FIXED LOD expression calculates the sum of sales per region and repeats that value on every row for that region.

❓ visualization

advanced

Choose the best visualization to compare sales by category and region

You want to compare total sales (a measure) across different product categories and regions (dimensions). Which Tableau visualization type is best suited for this?

A A stacked bar chart showing sales by category with colors representing regions.

B A line chart showing sales over time.

C A scatter plot with sales on X-axis and categories on Y-axis.

D A pie chart showing sales distribution for a single category.

💡 Hint

Think about comparing multiple categories and regions side by side.

A stacked bar chart allows easy comparison of sales across categories and regions simultaneously.

🔧 Formula Fix

expert

Identify the error in this Tableau calculated field mixing dimensions and measures

This calculated field is intended to calculate average sales per customer segment:

IF [Customer Segment] = 'Corporate' THEN AVG([Sales]) ELSE SUM([Sales]) END

What is the main issue with this calculation?

A The calculation will return the total sales for all segments regardless of condition.

B You cannot use aggregation functions like AVG and SUM inside an IF statement without proper aggregation context.

C The calculation will cause a syntax error because ELSE is missing a condition.

D The calculation will work correctly because IF supports aggregations inside.

💡 Hint

Aggregations inside conditional statements need careful handling in Tableau.

Tableau requires consistent aggregation levels; mixing aggregated and non-aggregated fields inside IF causes errors.