Optimizing DAX calculations

Optimizing DAX calculations for performance is hugely complicated and a vast subject that arguably deserves its own book. This recipe introduces the subject of how to analyze DAX calculations for performance and provides a number of techniques for optimizing the performance of DAX calculations.

Getting ready

To prepare for this recipe, perform the following steps:

1. Open Power BI Desktop.
2. Create a new table, R11_Table, using the following formula:

R11_Table = 
    ADDCOLUMNS(
        SELECTCOLUMNS(
            GENERATESERIES(1,1000000),
            "ID",[Value]
        ),
        "Value",100
    )

3. Create the following measures:

Sum 1 = 1000000 * 100

Sum 2 = COUNTROWS('R11_Table...