Need help adding criteria to existing DAX formula.

[krichmond]

I have this DAX statement that works but I need to add a second piece of criteria to row 10. I need to have both "Missing Media" OR "Reprocess File".

Has Missing Media? =

var _Column=

SELECTCOLUMNS(

    FILTER(ALL('Client Manager Report For Power BI'),'Client Manager Report For Power BI'[Event Id]=EARLIER('Client Manager Report For Power BI'[Event Id])),"1",'Client Manager Report For Power BI'[DBM Stage])

var _falg=

    CALCULATE(

    DISTINCTCOUNT('Client Manager Report For Power BI'[DBM Stage]),FILTER(ALL('Client Manager Report For Power BI'),'Client Manager Report For Power BI'[Event Id]=EARLIER('Client Manager Report For Power BI'[Event Id])))

return

IF(

    _falg =1 && "Missing Media" in _Column,TRUE(),FALSE())

[johnt75 · Accepted solution]

I think you can use

Has Missing Media? =
VAR _Column =
    SELECTCOLUMNS (
        FILTER (
            ALL ( 'Client Manager Report For Power BI' ),
            'Client Manager Report For Power BI'[Event Id]
                = EARLIER ( 'Client Manager Report For Power BI'[Event Id] )
        ),
        "1", 'Client Manager Report For Power BI'[DBM Stage]
    )
VAR _falg =
    CALCULATE (
        DISTINCTCOUNT ( 'Client Manager Report For Power BI'[DBM Stage] ),
        FILTER (
            ALL ( 'Client Manager Report For Power BI' ),
            'Client Manager Report For Power BI'[Event Id]
                = EARLIER ( 'Client Manager Report For Power BI'[Event Id] )
        )
    )
RETURN
    IF (
        _falg = 1
            && ( "Missing Media"
            IN _Column
            || "Reprocess File" IN _Column ),
        TRUE (),
        FALSE ()
    )

[TomasAndersson]

Hi!
Have you tried just wrapping in an OR() statement? E.g.:

OR("Missing Media" in _Column, "Reproess file" in _Column)

[krichmond]

@TomasAndersson - I am extremely new to DAX so I am not quite sure how to do that. Any chance you can send me what the modified line of code should look like? I tried the below and got this error.

[TomasAndersson]

Sure,

_falg = 1 OR("Missing Media" in _Column, "Reprocess file" in _Column), TRUE(), FALSE())

So you need to have the "in _Column" in both cases