Filter Data based on IF condition - 2 tables

[Ritesh_Air]

Hello,

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

Guidance = LOOKUPVALUE('SKU Guidance'[Guidance],'SKU Guidance'[2nd Item Number],'Item'[Product SKU])

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

[parry2k · Accepted solution]

@Ritesh_Air you can add this as a measure:

Guidance Measure = 
IF ( SELECTEDVALUE ( CustomerTable[Customer] ) = "NM", 0, MAX ( ItemTable[Guidance] ) )