Adding complex formulas
This article will guide you on how to add complex formulas when adding a formula. This could be used when having different conditions on a particular measure or data point.
2. Setting Up
To get started, we will use AdventureWorks2012 with Sales.SalesTerritory, using Name as measure and SalesYTD as our measure.
3. Adding a complex formula
To add a formula, on the menu bar, click on the table, go to Modify Data > Add Formula.
Once the formula bar has opened, click on the advanced button on the right of the formula bar
The formula bar will expand. You could type your conditions for your table or chart.
Once you have your conditions set, click Apply, and you will see a new measure called "Script Measure".
4. Changing Script Measure Column
To change the name of the column "Script Measure", open the Data Binding Panel, and click on the Edit icon for the Script Measure.
In the "Configure metric set element" box, under Caption, change the name of "Script Element" to the name you want to place.
Under the "Metric Set Default Values", you could change the aggregators and format, and add symbols to the column.
Select submit, and you will see the change to the table.