Correct my Syntax: not in ("Qualified", "Unqualified")

[teresadanna]

I'm hoping to create the following logic and I'm just not sure what the correct syntax is. Hopefully this is an easy one

IF(table[Stage] not in ("Qualified","Unqualified"), 1, 0)

IE if the stage isn't qualified or unqualified then include it in the data

[Anonymous · Accepted solution]

IF(AND(table[Stage]<>"Qualitfied", table[Stage]<>"Unqualified"),1,0)

For the syntax of IN refer to the post https://www.sqlbi.com/articles/the-in-operator-in-dax/. It uses Curly brackets instead of round.