How to compare two column with string values?

Hi @Parvane_Zand,
Welcome to eazyBI community!

​It seems you were missing the function CoalesceEmpty, which helps determine what to return if the field is empty. Try the formula below and see if it returns the expected results

​IIF(
CoalesceEmpty([Measures].[Object Volume Host],"") MATCHES 
CoalesceEmpty([Measures].[Object Volume Server Host],""),
"Equal",
"Not Equal"
)


​Best wishes,

Elita from support@eazybi.com