Hi guys,  Any one here can solve the following issue ; I have a cube in SSAS with sales measure, Sales Measure which is a fact table has Sales Amount, Tax, Order Quantity etc. Now,my question is, how do I get the sales amount column appear color appear red or green depending on the sales amount eg. <5000 .. I also have a calculated member Average sales , which i computed as Measures.SalesAmount/Measures.OrderQuantity and there I tried the following conditions but, I get the Average Sales column colored and nothing in the sales amount column..I want to get the sales amount color change depending on the conditions. I have attached jpeg file for reference.  Thanks for your help. IFF([Measures].[Sales Amount]>50,255,65280)