The DAX tab within the Measure Calculations wizard allows you to create quick predefined DAX calculations. This tab appears only when the workbook is connected to a tabular data source.
Calculation types
The calculations below are available:
Aggregate by category
You will need to select a column called category. For example, selecting City in a Max per Category calculation would return the highest measure value for all cities (applying all filters in the grid).
- Average per category
- Variance per category
- Max per category
- Min per category
- For a weighted average calculation, you also need to choose the value that'll be the weight. This can be a measure or an aggregate of a column.
Filters
These calculations require a member from a column to calculate the Measure value for that particular row.
- Filtered value
- Difference from filtered value
- Percentage difference from the filtered value
Time intelligence
For time-related calculations, a date column, as defined in the model, must be selected. Year-over-year, etc. calculations also require a number representing the number of years or months, etc. over which to calculate the change.
- Year-to-date total
- Quarter-to-date total
- Month-to-date total
- Year-over-year change
- Quarter-over-quarter change
- Month-over-month change
Totals
- Total for subcategory (filters applied)
- Total for subcategory (filters not applied)
Mathematical operations
These calculations require a value to operate with - this can be a measure or an aggregate of a column.
- Addition
- Subtraction
- Multiplication
- Division
- Percentage difference
Managing Calculations
As with other custom calculations in Anaplan XL, DAX calculations can be edited or deleted in the Custom Calculations wizard. This wizard can also be used for creating custom DAX calculations.
