Forum Discussion

Eiji77's avatar
Eiji77
Helper II
7 years ago
Solved

and or

    New GOAL = FILTER('Table 2',’Table 2'[STATUS]="D"||Table2'[STATUS]="E"&&RELATED('Table 1'[STATUS]<>"E") Is this formula correct?
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Eiji77

     

    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's avatar
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's avatar
    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's avatar
      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. 

      • Eiji77's avatar
        Eiji77
        Helper II
        7 years ago

        Anonymous

        I understand! Thank you!