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 DAXDAX Measure:Measure name =SUMX (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])

rishari Can you post sample data so can test and optimize.

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] )

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])

johnt75 - I need a single value to add in the matrix.

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

DAX Optimization SUMX ( SUMMARIZE ) - Performance Issue

Forum Discussion

Related content

DAX performance optimization

performance optimization for direct query in power bi

Optimize SUMX with SUMMARIZE

DAX Performance Optimization for High-Granularity Analysis

DAX Optimizing SUMMARIZE()