Sumproduct by groups in power bi

[Anonymous]

Hey Guys, 

I have created a measure to do a weighted average for one of my metric, i have used summarized and as expected the performance has just been bad. Any suggestions on how i can improve the below query:

## Sumx Retail OOS =

var Retail_AGG_OOS = SUMX(SUMMARIZE(pbi_sc_buy_box, DIM_ASIN[ASIN],pbi_sc_buy_box[brand_key], "SUMPROD",[## Retail OSS]*[## 90 day retail cogs]), [SUMPROD])

return DIVIDE(Retail_AGG_OOS,[## 90 day retail cogs],0)


[## Retail OSS] and [## 90 day retail cogs] are also measures but simple ones. If further explanation is required, please feel free to ask. 

Thanks

[v-cherch-msft]

Hi @Anonymous 

Please have a look at below article to check if it could help you.

https://www.sqlbi.com/articles/optimizing-dax-expressions-involving-multiple-measures/

Regards,

Cherie

[v-cherch-msft]

Hi @Anonymous 

Sample data and expected output will be helpful to provide an accurate solution.

Regards,

[Anonymous]

Hey

unfortunately, i couldn't provide the sample data or a pbix file. Although i was able to solve the issue by using groupby and addcolumns instead of summarize. 

For anyone struggling with summarize should definitely check out this article: https://www.sqlbi.com/articles/nested-grouping-using-groupby-vs-summarize/

Thanks

[Anonymous]

Thanks @v-cherch-msft. Nice article although it didnt help in my case.