Working with Calculated Measures
Before you create a calculated measure, you should think about the fields and operators you want to include. To learn about the type of fields and basic operators that you can use in your calculations, see Supported Calculations.
You can define your calculated measure using fields from the dataset connected to your workbook visualization. In visualizations based on linked datasets, this means you can use any combination of fields from either dataset. If you don't see the fields you want to use, edit the connected datasets or contact the dataset owner if you're not the original author. For more information, see Editing a Dataset.
After you've created a calculated measure, you can use it to sort and filter your results. Calculated measures support all sorting and filtering options available for base measures. You can also change the format of a calculated measure's numbers, add totals and grand totals, and apply conditional formatting. For more information about these options, see Workbook Visualization Filters, Pivot Table Customization, and Conditional Formatting.
To open the calculated measure editor, click Create Calculated Measure in the Layout panel of any pivot table or chart. You can create as many calculated measures as you need, but you can only use them in the workbook visualization where you made them. If you want to use the same calculated measure in other visualizations, copy and paste the measure definition.
To learn how to work with calculated measures, see the following: