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
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

rishari 

Please try

MeasureName =
SUMX (
SUMMARIZE (
FILTER ( table_name, table_name[Counter] = 1 ),
table_name[Col1],
table_name[Col2],
table_name[col3],
table_name[col4],
table_name[col5],
"result", COUNTROWS ( VALUES ( table_name[col1] ) )
),
[result]
)

  • rishari's avatar
    rishari
    Frequent Visitor
    3 years ago

    Hi tamerj1 - I tried this, but instead of numbers, I'm getting blank

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

      rishari 

      Please try

      MeasureName =
      SUMX (
      FILTER (
      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] )
      ),
      [@Conter] = 1
      ),
      [@Result]
      )

      • 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