Forum Discussion
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 ...
tamerj1
Community Champion
Community ChampionPlease 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]
)
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
rishari
TryMeasureName = 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] ) )