DAX Query

[Sagar Hanchate]

Hi All,
Can any one please help me on fixing below Dax query;


The below query works fine as I have passed two conditions in OR. But now I need to pass couple of more conditions.
like
Target[SR]="APAC"
Target[SR]="EMEA"
Target[SR]="AMR"
Target[SR]="ICA"

"EVALUATE CALCULATETABLE( Target, Target[Last Year Flag]=1, FILTER( Target, or (Target[SR]="APAC",Target[SR]="EMEA")) ) "

 

[Matt Allington]

Use double pipe for or inside filter

Target[sr]="apac" || target[sr]="Emma"

 

[Sagar Hanchate]

Thanks a lot. worked perfectly

 

[Sagar Hanchate]

Any idea how do i write <> blank in filter( not equal to blank condition)

 

[Matt Allington]

I think it is ISNOT(BLANK()) but can't be sure. Also try <>""