The Concatenate measure appends all values in the subset into a string.
The Unique Concatenate measure appends all unique values in the subset into a string. This means that each value will only be included in the string once.
Example:
Column A |
Column B |
Column C |
1 |
1 |
1 |
1 |
|
3 |
1 |
3 |
3 |
With the columns from the table above, the following result would be given:
Column |
Concatenate |
Unique Concatenate |
A |
1, 1, 1 |
1 |
B |
1, 3 |
1, 3 |
C |
1, 3, 3 |
1, 3 |
See also: