Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. From Toolbox, select Semantic Models.

  2. Select a semantic model and click the Add Measure button, which is the plus sign next to the column name.

    1. If there are no measures or groups, a measure group is added.

    2. If a measure is selected, another measure is added to the group.

    3. If a measure group is selected, a measure is added to that group.

  3. To add a measure group, click the down arrow next to the plus sign and click Add Measure Group.

  4. Click the measure or measure group and enter a name in the Properties panel.

  5. Do one of the following:

    1. Drag a measure (except calculated measures) into a group.

    2. Right-click the measure group, click Add Measure, and enter a name for the measure.

  6. If there is not already a default measure, click the Default checkbox to make this measure the default used for new visualizations.

  7. Click to create an expression.

  8. Enter the solve order or use the default value. 

    1. Change the solve order if this expression needs to be calculated to be used in another expression. Then enter the expression.

    2. Set the non-empty behavior to By Expression, By Measures, or By Measures Then Expression.

  9. If By Measures or By Measures Then Expression is selected, select the measure used to evaluate the expression. Type in the Search box to quickly find a measure or click a checkbox to select a measure from the list.
    This option can improve query performance because the calculation is only done if the values used in it are not empty.

  10. If By Expression is used to calculate non-empty behavior, enter an expression.

  11. To create an expression, start typing in the editor. Dimensions and functions display as you start to type their names.

    1. As you enter text, suggested functions, semantic models, dimensions, members, and so on, are displayed. Click a name, then press Enter to use that item.

    2. Click the Functions tab to view additional detail about the available functions.

    3. Use the Undo and Redo icons as needed as you create your calculated expression. 

    4. To find or replace content, click the Find/Replace icon and enter what to find.

    5. Select the Match Case icon (Aa) if needed.

    6. 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.

    7. To delete the entry for that item, click the X at the end of the line.

    8. Click Validate to validate the expression.

    9. Click Save.

  12. Enter a display folder name. You can use the semicolon for multiple display folders or backslash to nest folders.

  13. Specify whether to materialize the measure. Yes means this field will be part of the built cube.

  14. Optionally, select the Visible checkbox to display the measure for use in worksheets. If you don’t want users to use this data directly, you can clear it.

  15. Optionally, add a description of up to 200 characters. The description is used when you hover the cursor over the measure in a worksheet.

  16. Click Save.

You have a lot of flexibility for formatting data. To learn more, see Formatting measures.

...