Forum Discussion

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

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

Eiji77

Helper II

7 years ago

Anonymous

I understand! Thank you!

v-frfei-msft

Community Support

7 years ago

Hi Eiji77,

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

Regards,

Frank