Filter Data based on IF condition - 2 tables

Hello,

I have a file called SKU guidance which is maintained on SharePoint. I added those Guidance values on Item table by using LOOKUPVALUE.

Now I have Customer table which has Member Type Code:

Now I have a visual table which have bunch of columns including Member Type Code and Guidance.

My objective is:

Whenever there is a Member Type Code is NM then guidance should be 0, otherwise whatever the Guidance. 
My question is how do I achieve that? I am getting confused if I need to create a column or a measure? Thanks in advance.

Thanks,

RK