and or

[Eiji77]

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

Is this formula correct?

[Anonymous]

@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]

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]

@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]

@Anonymous

I understand! Thank you!

[v-frfei-msft]

Hi @Eiji77,

Kindly mark the answer as solution to close the case please.

Regards,

Frank

[Anonymous · Accepted solution]

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