Need Help with DAX Statement

[NickProp28]

Hi experts, 

Good day, 

I new to DAX, hoping someone can help me on conditional code.

Based on the table,

The first condition is, I only want get the data (Profit) which Origin/Dest is under MYKUL,MYPEN,CNSHA,SGSIN. Other from this, data(Profit) will ignore.

Second condition , if Original=Dest. Data will be ignore too (Example like CNSHA=CNSHA).

Hope you will have a great day!
Best thanks.

[amitchandak · Accepted solution]

@NickProp28 , something like this

calculate(sum(table[profit]), filter(Table, table[origin]<>table[destination] && table[origin] in {"MYKUL","MYPEN","CNSHA","SGSIN"}
&& table[destination] in {"MYKUL","MYPEN","CNSHA","SGSIN"}))

[NickProp28]

Dear @amitchandak,

Thanks for your quick response. I have one more question, if i wound like to use LIKE statement. (LIKE 'SG%','MY%' in sql)

In this case, how the code would like be? 

Best regards

[amitchandak]

@NickProp28 ,

https://docs.microsoft.com/en-us/dax/containsstring-function-dax

https://docs.microsoft.com/en-us/dax/search-function-dax

https://docs.microsoft.com/en-us/dax/find-function-dax