KB16881: How to create an adaptive metric that will calculate different metrics based on the DESC attribute form of an attribute in MicroStrategy Developer 9.x

Consider the following scenario using the Strategy Tutorial project. A user wants to calculate the 'Revenue' value when the attribute 'Category' displays the value 'Books' but wants to display the 'Profit' value when Category displays any other value.
 
The user must create an adaptive metric that decides which metric to apply depending on the value of the attribute. To achieve this, follow the steps below:
 

• Create a metric with the following definition:
   
  

•  
  Max(Category@DESC) {~, Category}
  
• Save this metric as M1.
• Create a new metric with the following definition and save it:
   
  

•  
  Case(( = "Books"), Revenue, ( <> "Books"), Profit)
  
• Add it to the report. Notice that the 'case statement' metric calculates the Revenue value when the attribute 'Category' displays 'Books' and calculates the 'Profit' value for any other elements of 'Category', as shown below:
  

For more information on adaptive metrics, refer to the following Strategy Knowledge Base technical note:
 
KB11067 (KB5200-75x-0459): What is an adaptive metric in Strategy?