Set Analysis with Multiple Conditions

[Eli181]

Hi.

I spent a couple of days to address this issue ... with no luck. Could anyone help:

I would like to develop a measure (or a variable) that

1. DISTINCT COUNT customers when

Value in Column A = 1

AND

Value in Column B1 <> 1 OR Value in Column B2 <>1

AND

Value in Column C1 <> 1 OR Value in Column C2 <>1

I tried

count(distinct{$<Column A={'1'},

<Column B1-={'1'}>+<Column B2-={'1'}>,

<Column C1-={'1'}>+<Column C2-={'1'}>}Customer)

Buy it gives me an Error Expression MEssage.

Thank you very much for your help.

E

[Anil_Babu_Samineni]

Perhaps this?

Count(distinct If([Column A]=1 and ([Column B1] <> 1 OR [Column B2] <>1) and ([Column C1] <> 1 OR [Column C2] <>1), Customers))

[Kashyap_R · Accepted solution]

Hi 

Try this

Count(distinct{<Column A={'1'}>*(<Column B1-={'1'}>+<Column B2-={'1'}>)*

(<Column C1-={'1'}>+<Column C2-={'1'}>)}Customer)

Hope it helps 

Thanks

[tresesco]

Try like:

count(distinct{$<Column A={'1'}>*

(<Column B1-={'1'}>+<Column B2-={'1'}>)*

(<Column C1-={'1'}>+<Column C2-={'1'}>)}Customer)