---
schema_version: "1"
id: a00125f8e1e93180cdf9a8905b10200742565d4dd594722326ada0b87a4bdf96
title: Defining Unique Values
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/pro/desktop/buildmanual_multidimensional_uniquevalues.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-gb/buildmanual_multidimensional_uniquevalues.htm
source_site: help.tableau.com
content_type: documentation
content_hash: f24de7f752a1612c043ea29ead54757131fe0e1efaf11ee68ccd269b5371efe4
description: Understand how Tableau distinguishes duplicate member names in cube data sources by qualification.
---
[Skip to main content](#main-content)

# Defining Unique Values

**Note**: The following applies only to certain multidimensional (cube) data sources.

Sometimes, when you are building views in Tableau, a field will have multiple members with the same name. For example, you may have a view showing the average profit by month over several years. The month February appears multiple times (once for each year).

![The month February appears twice on a line chart, once for each year.](/tableau/current/en-gb/pro/desktop/en-gb/Img/wwd_uniquevalues1.png)

While the name, February, is repeated, each instance of February can either be considered similar or unique. If you consider them similar, they will appear in the same column if you decided to move the Year field to the Colour. However, if you consider them unique, they will be treated as two different values.

![Two line charts, one with overlapping lines and non-unique month values, another with separate lines and unique month values.](/tableau/current/en-gb/pro/desktop/en-gb/Img/unique_values3.png)

It is generally okay to consider repeated names within date and time fields (like in the previous example) similar but if there are repeated names in the Customer Name field, you won’t want to consider the two customers as the same person.

To define how you want Tableau to determine whether repeated values are unique, right-click (control-click on Mac) on the dimension in the Data pane and select one of the following on the Unique Values context menu:

- By Key: each member is considered unique based on the key given to it by the system administrator when the database is set up. Members with the same name but different keys are treated as unique values.
- By Name: each member is considered unique based on the member name. Members with the same name (regardless of their keys) are treated as if they are the same.

By default, unique date and time values are determined by name and all other values are determined by key.