When browsing a data source, sometimes the provided Measures are not always enough for a user’s needs. In Managed BI, users have the ability to create custom calculations using existing Measures within the selected data source. They allow users to save and share calculations that are frequently used, but not part of the list of provided Measures in the data source.
To add a Calculated Field/Measure:
- Click the Add Calculated Field icon.
- Select New Calculated Measure in the drop-down.
- Enter the desired Name of the new Calculated Field.
- Enter the custom formula.
- Select the desired Format of the new Calculated Field.
- Select the Security setting for the new Calculated Field:
- Report – saves the Calculated Field in the report only.
- Private – saves the Calculated Field into the user’s private library, which can be accessed by the user only at a later time.
- Public – saves the Calculated Field into a shared library, which can be accessed by other users at a later time.
7. Click Add, then Close.
