Forum Discussion
Nested IF formulas with OR statement
Break it down into two if statements using 1 for the positive result and 0 for the negative result. Then write a third if statement referencing the two if statements to week out the negatives. Finally, use that last statement in a Calculate.
Sample = CALCULATE([Total Orders], [Both Criteria]=1)
Of course if you provide sample data or a snip we can better help you solve this. I am just spitballing ideas based solely upon your question.
Could you please provide us more detail information about your data model? Generally, we can add multiple conditions in IF function, such as
Measure = IF((Condition1 && Condition2 && Condition3) || (Condition4 && Condition5), "Ture value","False Value")
Regards,
Charlie Liao
Break it down into two if statements using 1 for the positive result and 0 for the negative result. Then write a third if statement referencing the two if statements to week out the negatives. Finally, use that last statement in a Calculate.
Sample = CALCULATE([Total Orders], [Both Criteria]=1)
Of course if you provide sample data or a snip we can better help you solve this. I am just spitballing ideas based solely upon your question.