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

Anonymous

Not applicable

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