Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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')
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')