Weighted Average - Arithmetic Mean

[Syndicate_Admin]

Good afternoon

We have been working for several weeks on being able to make a Weighted Average/Arithmetic to include it in a dashboard. The problem is that we only get the "normal" average and it is a puzzle. If anyone has the solution would be appreciated

If anyone knows the solution to add the weighted to add it to the "average leadtime" box.

Thank you

[Syndicate_Admin]

Good morning

Where the data would come from would be here:

Thank you

[amitchandak]

@Syndicate_Admin , Need a sample data for that.

But

divide(Sumx(Table, [Col1] * [col2]), Sumx(Table, [Col2]) )

should help

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.