New GOAL = FILTER('Table 2',’Table 2'[STATUS]="D"||Table2'[STATUS]="E"&&RELATED('Table 1'[STATUS]<>"E")Is this formula correct?

and or | Microsoft Fabric Community

6 Replies

Anonymous

Not applicable

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

Anonymous
Not applicable
7 years ago
Eiji77
You can also use the following expression. It will produce the same result as the one I posted before:

New Goal2 = CALCULATETABLE ( Table2, OR ( Table2[STATUS] = "D", Table2[STATUS] = "E" ), Table1[STATUS] <> "E" )
The filter arguments in CALCULATETABLE are always put in a logical AND condition.
- Eiji77
  Helper II
  7 years ago
  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.
  - Anonymous
    Not applicable
    7 years ago
    Eiji77
    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.

Forum Discussion

and or