Multiple values for one dimension

[#1]

Hello,

I want to create an expression to check if a dimension has more than one value.

For example:

Customer ID     Product ID

11                        1

11                        2

15                        3

15                        4

16                        5

Customer 11 has 2 products.

I want an expression to check if one customer has 1 product or more than one.

Thanks!

[settu_periasamy · Accepted solution]

Hi,

if your Dimension is Single(Customer ID only), you can try the normal expression in straight table, like

=if(Count([Product ID])>1,'More than One','One')

if you have more dimension, you need to try the aggregation like

=if(Aggr(Count([Product ID]),[Customer ID])>1,'More than One','One')