Color Expressions in SSAS Calculations
Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Saint Augustine, FL. Bradley is a former consultant, trainer, and has coauthored 6 SQL Server and Power BI books, most recently Learn Microsoft Fabric. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. Bradley gives back to the community through speaking at events such as the SQLBits, Fabric Community Conference, PASS Community Data Summit, SQL Saturdays, Code Camps, and user groups across the country including locally at the Jacksonville SQL Server User Group (JSSUG). He is a contributor on SQLServerCentral.com and blogs on his personal site, BradleySchacht.com.
Simply enter a condition in the box as shown above when the results of the condition being the colors you would like the text to be. There is even a little color picker to the right of the expression box that will help you get the right code for the color you choose. The format is: IIF([Measures].[MeasureName] Evaluation Expressions, True Result, Else Result) For instance, IIF([Measures].[Internet Average Sales Amount] > 750, 32768, 0) This translates to If the measure Internet Average Sales amount is greater than $750 then make the text green, otherwise keep it black. You can nest statements and create some pretty complex conditions here, but I'll leave that up to each of you to explore. When we browse the cube you will now notice that the values for that measure over $750 appear green while everything else is in black. One nice thing is that this carries over into Excel. So when a user browses in an environment they are familiar with they will be able to take advantage of your color expressions without any additional work! 
We can now see that for our sales territories in the United States the Northwest and Southwest regions are above the threshold. North America as a whole is also overall above average. Everyone else is behind the curve ball and still shows up in plain black text. Unfortunately this does not carry over to SSRS, but the same functionality can be created with an expressions on the text box.