Replace "N/A" to a blank

[mbalraj]

Hello

I have a measure which I use in a State map as follows,  Acccount_State = Account[Ship Country]&", "&Account[Ship State]&", "&Account[Ship_City]

Expected result is United States, Texas, El Paso

Sometimes the Ship state field contains "N/A". In such rows, I would like to replace "N/A" with just blank as such

United States,,El Paso. How should I write the Account_State measure to return this result. 

Will  a blank state showup correctly or else what should I do?

[amitchandak · Accepted solution]

@mbalraj , Try like, In DAX

Acccount_State = Account[Ship Country]&", "& if(Account[Ship State]= "N/A",blank() , Account[Ship State] ) &", "&Account[Ship_City]