Forum Discussion
Solved
and or
New GOAL = FILTER('Table 2',’Table 2'[STATUS]="D"||Table2'[STATUS]="E"&&RELATED('Table 1'[STATUS]<>"E") Is this formula correct?
AND and OR are functions in the DAX, so maybe you can write it as follow:
New Goal = FILTER ( Table2, AND ( OR ( Table2[STATUS] = "D", Table2[STATUS] = "E" ), RELATED ( Table1[STATUS] ) <> "E" ) )
Thank you Anonymous !
I have one more question.
Can the AND and OR functions be used when there are three or more filter items?
In the case of this time, the goals are D, E, F etc.
yes, you can use as many as you want, for example :
OR( OR(D, E), F) which equals to D || E|| F
For and as well,
AND(AND(D,E),F) which equals to D && E && F
but you have to take care of the combination of these two.
Anonymous
I understand! Thank you!
