DAX comparison operator with and statements

[poweruser55]

I am getting a dax comparison error. I have two statements OLI Status needs to be active status needs to equal 20 and fc flag needs to be = "N", the next statement is OLI Status needs to be active status needs to equal 80 and fc flag needs to be = "Y". Not sure what is incorrect.

[amitchandak · Accepted solution]

@poweruser55 , Check if _C_SP_status is number or text, Check same for other two columns two , if text put value in  double quote

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.