Forum Discussion

rishari's avatar
rishari
Frequent Visitor
3 years ago

DAX Optimization SUMX ( SUMMARIZE ) - Performance Issue

I'm not able to optimize this measure. I'm new to Power BI DAX. Kindly suggest me a way to run this DAX faster. If I am wrong, please suggest me any other alternative way to achieve the below DAX ...
DAX Optimization
Performance Issue
SUMMARIZE. SUMX
johnt75's avatar
johnt75
Super User
3 years ago

Its not best practice to use SUMMARIZE to add calculated columns, its better to use ADDCOLUMNS, e.g.

MyMeasure =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE (
            'table_name',
            'table_name'[Col1],
            'table_name'[Col2],
            'table_name'[col3],
            'table_name'[col4],
            'table_name'[col5]
        ),
        "result",
            CALCULATE (
                DISTINCTCOUNTNOBLANK ( 'table_name'[col1] ),
                FILTER ( 'table_name', SUM ( 'table_name'[Counter] ) = 1 )
            )
    ),
    [result]
)