Validating ) symbols in cells

[justinleow]

Dear all,

would like to ask how can I validate if a cell ends with brackets.

(324) = Ok
234 = Not ok
(265) = Ok
(155) = Ok
44f = not ok
345632) = Ok

This does not work as the bracket will close the if statement. 
= if(right('table'[Column1],1)=")","Ok","Not Ok")

[Stachu]

the code you posted works for me in DAX - why it doesn't work for you?