Sometimes there is a simple way to solve an issue. For example, if you want to color all measures (including calculated measures) in red when the value is negative, you can simply write:

SCOPE( Measures.AllMembers );     FORE_COLOR(THIS) = IIF( Measures.CurrentMember < 0, 255, 0);  // 255 = RED END SCOPE;

 

MDX Script is so better than classical properties for each measure in these cases…

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2007/07/28/red-color-for-negative-numbers-in-analysis-services-2005.aspx