Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • DAX Calculations

    The DAX tab within the Measure Calculations wizard can be used to create quick predefined DAX calculations. This tab appears only when the workbook is connected to a tabular data source.

    Calculation Types

    The following calculations are available:

    Aggregate by Category

    You will need to select a column which is the '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).

    For a weighted average calculation, you also need to select the value which will act as the weight. This can be a measure or an aggregate of a column.

    • Average per category
    • Variance per category
    • Max per category
    • Min per category
    • Weighted average per category
    DaxCalcs Category1.PNG

    Filters

    These calculations require a member from a column and calculates the measure value for that particular row.

    • Filtered value
    • Difference from filtered value
    • Percentage difference from 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 which represents 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 XLCubed, DAX calculations can be edited or deleted in the Custom Calculations wizard. This wizard can also be used for creating custom DAX calculations.

    See Also