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
rishari's avatar
rishari
Frequent Visitor
3 years ago

Hi tamerj1 - I'm getting the value now. It loads much faster. But still we have more granularity, hence it is not loading in the matrix. It takes much time

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

rishari 
Try

MeasureName =
SUMX (
    SUMMARIZE (
        table_name,
        table_name[Col1],
        table_name[Col2],
        table_name[col3],
        table_name[col4],
        table_name[col5],
        "@Result", COUNTROWS ( VALUES ( table_name[col1] ) ),
        "@Counter", SUM ( table_name[Counter] )
    ),
    IF ( [@Conter] = 1, [@Result] )
)