Select If DAX for 2 conditions

[Bbrown44]

I have a table which is structured like the picture below:

I wanted to create a measure where:

IF (Outreach Status = 'Outreach Needed' OR CL36B - BP 09272019.Outreach Status ='Outreach Needed'

Then, "Outreach Needed"  ELSE "No Outreach Needed")

Please advise,

[v-diye-msft]

Hi @Bbrown44 

Try this one:

IF (MAX('Table'[Outreach Status]) = "Outreach Needed" ||MAX('Table'[CL36B - BP 09272019.Outreach Status]) = "Outreach Needed", "Outreach Needed" , "No Outreach Needed")

[amitchandak · Accepted solution]

Is this not working for you

IF (Outreach Status = 'Outreach Needed' ||  CL36B - BP 09272019.Outreach Status ='Outreach Needed', "Outreach Needed" , "No Outreach Needed")

You need to choose tablename[columnname]