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" ) )
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!
