Count OR

[Taylorcc]

Hello

I want to count each patient once if they have at least one of the items = 1 

This is what I am trying to use but it is counting all patients 

=count(distinct if(PreferredLanguageFlag='1' or
CountryofBirthFlag='1' or
EthnicityFlag='1' or
InterpreterFlag='1',
[Patient]) )

Does anybody know where I am going wrong? 

Thank you

[Lisa_P · Accepted solution]

Using Set Analysis:
=count({<PreferredLanguageFlag={'1'}, CountryofBirthFlag={'1'}, EthnicityFlag={'1'}, InterpreterFlag={'1'}>}distinct [Patient]) 

[lironbaram]

hi 

your expression looks ok 

why do you think it doesn't work?