Forum Discussion
Multiple OR
pramita, instead of "OR", try "||" instead. Good luck.
Just like what musicbydannyd suggested, OR can only add two conditions,e.g OR(OR(condition1,condition2),condition3.
However || can add more than 2 conditions, e.g. condition1 || condition2 || condition3 ||....||condition N.
pramita , try like
DI JR = DIVIDE(CALCULATE( COUNTROWS('INPUT'),filter('INPUT', 'INPUT'[Level] = "JR", OR( OR( OR( OUTPUT[Q1] < 4, OUTPUT[Q5] < 4 ), OR( OUTPUT[Q7] < 4, OUTPUT[Q8] < 4 ) ), OUTPUT[Q11] < 4) )), DISTINCTCOUNT(OUTPUT[Email Address]))Hi pramita
Try below:
DI JR = DIVIDE ( CALCULATE ( COUNTROWS ( INPUT ), VALUES ( 'INPUT'[Level] ) = "JR", FILTER ( OUTPUT, OR ( OR ( OR ( OUTPUT[Q1] < 4, OUTPUT[Q5] < 4 ), OR ( OUTPUT[Q7] < 4, OUTPUT[Q8] < 4 ) ), OUTPUT[Q11] < 4 ) ) ), DISTINCTCOUNT ( OUTPUT[Email Address] ) )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandakSuper User
pramita , try like
DI JR = DIVIDE(CALCULATE( COUNTROWS('INPUT'),filter('INPUT', 'INPUT'[Level] = "JR", OR( OR( OR( OUTPUT[Q1] < 4, OUTPUT[Q5] < 4 ), OR( OUTPUT[Q7] < 4, OUTPUT[Q8] < 4 ) ), OUTPUT[Q11] < 4) )), DISTINCTCOUNT(OUTPUT[Email Address])) - v-juanli-msftCommunity Support
Hi pramita
Try below:
DI JR = DIVIDE ( CALCULATE ( COUNTROWS ( INPUT ), VALUES ( 'INPUT'[Level] ) = "JR", FILTER ( OUTPUT, OR ( OR ( OR ( OUTPUT[Q1] < 4, OUTPUT[Q5] < 4 ), OR ( OUTPUT[Q7] < 4, OUTPUT[Q8] < 4 ) ), OUTPUT[Q11] < 4 ) ) ), DISTINCTCOUNT ( OUTPUT[Email Address] ) )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - musicbydannydAdvocate IV
pramita, instead of "OR", try "||" instead. Good luck.
- ryan_mayuSuper User
Just like what musicbydannyd suggested, OR can only add two conditions,e.g OR(OR(condition1,condition2),condition3.
However || can add more than 2 conditions, e.g. condition1 || condition2 || condition3 ||....||condition N.