Comparing Text in two columns of a Chart

[Anonymous]

I have a single chart with columns in alternate states.  I am using a formula to highlight cells in yellow when the value in the two states do not match.  This formula is:

=If((Sum({[Chart 1]} Group)) <> (Sum({[Chart 2]} Group)), yellow())

This formula works great in the background color function of the expression when the value is a number.  However when the value is text, it does not work.  I think it has to do with it having "sum" but the expression fails when I delete it.  Any idea on what I can put it in place to make the expression work for text?

[sunny_talwar · Accepted solution]

May be use Only()

=If((Only({[Chart 1]} Group)) <> (Only({[Chart 2]} Group)), yellow())

[Anonymous]

That worked!  Thank you very much Sunny!