Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Weighted Average - Arithmetic Mean

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 i...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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.