Applies to:
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
Measure values can be calculated using expressions in MDX Linear syntax.
For example:
([Measures].[Field1] + [Measures].[Field2])
As you type, the auto-complete feature shows cube names, available dimensions, measures, and MDX functions.
To use the MDX editor when creating calculated measures in cubes, perform the following steps:
- Create or edit an existing semantic model.
- Choose to create a new measure.
- In Measure Properties, select Expression.
- On the Expression dialog box, specify the solve order if needed, and select a behavior for non-empty cells. Click the i icons to learn more.
- Start typing an expression in the editor section of the dialog box.
- As you enter text, suggested functions, semantic models, dimensions, members, and so on, are displayed. You can also see a description of the selected function.
To view a list of functions along with the detailed description, navigate to the Functions tab and select a function from the list.
Tips
- Double-click on the dialog header to access the full-screen mode.
- Use the Undo and Redo icons as needed as you create your calculated expression.
- To find or replace content, click the Find/Replace icon, and enter what to find.
- Select Match Case icon (Aa) if needed.
- If you want to replace the found value, click the arrow to the left of Find, enter the text to replace, and specify whether to replace all.
- To delete the entry for that item, click the X at the end of the line.
- Click Validate to validate your criteria.
If you have made changes and don’t want to keep them, click Cancel. - Click Save.
To learn more about MDX query fundamentals, see Microsoft Documentation.
To learn about the syntax elements and language references, see Microsoft Documentation.
Related topics