Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also have another little feature that adds just a little more wow when your end users browse the cube.
By building a color expression on a calculation you can change either the fore color or background color of a measure value. Here you can write an MDX expression that will change the font or background color of a cell when a user selects the calculation. A very basic example is below.