add_calculation_item
Add a calculation item to a calculation group, using DAX to wrap SELECTEDMEASURE() for time calculations like YTD. Set display order and dynamic format strings.
Instructions
Add a calculation item to a calculation group. The DAX usually wraps SELECTEDMEASURE(), e.g. "CALCULATE(SELECTEDMEASURE(), DATESYTD('Calendar'[Date]))" for a YTD item. ordinal sets display order; formatStringExpression sets a dynamic format for that item.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | item name, e.g. YTD | |
| table | Yes | the calculation-group table | |
| ordinal | No | display order (optional) | |
| sessionId | Yes | ||
| daxExpression | Yes | DAX expression, usually over SELECTEDMEASURE() | |
| formatStringExpression | No | DAX dynamic format-string expression for this item (optional) |