Expression For If Not and If It Is

[DMB90]

Hi,

I am trying to build a measure that says:

If column A does not say "No Population" then look and see if column B says "Complete" and if both are true then say "Ready for Review" and if not then pull whatever else is in Column B.

[DMB90]

Sorry, I meant if it's NOT "No Population" and the other column says "Complete" then follow the previous statements.

[ddpl · Accepted solution]

@DMB90  ok try this

[ddpl]

@DMB90 

Try this

 if its work please accept as solution.

[amitchandak]

@DMB90 , a New column would be best

but for a measure

if( max(Table[A]) = "No Population" && Max(Table[B]) = "Complete", "Ready for Review" , Max(Table[B]) )