Weighted Average - Percentage in relation to value of product

[AndrejZitnay]

Hello Guys,

Would you be so kind and help me with weighted Average? 
I am very new to measures &  DAX so I need your help.

I have Bar chart where I am showing %  of KPI against some products however avererage is not ideal as I need weighted average.

Can I do something like sumproduct in excel?

Below is just example of what I need to achive.

Will be this new measure still interactive in my chart?

Many thanks.

Andrej

[v-qiuyu-msft]

Hi @AndrejZitnay,

Can you share us the formula how you calculate the Regular Average and Weighted Average? It seems there should be other used data you didn't posted. Please share detail information, so that we can try to write DAX.

Best Regards,
Qiuyun Yu

[AndrejZitnay · Accepted solution]

Hello @v-qiuyu-msft,

I have managed to sort this out. I have used advices sumx formula. My original problem wasn't with formula but with wrong data.

Thank you for offering your help.

Andrej