Weighted Averages

Is there a way to use a dashboard to find weighted averages? My dashboard shows the average profit margin per scale/scope of a project. However, some of the projects are very tiny, and some of them are very massive. Any idea how I could make this happen?

Maybe try some sort of formula to find weight of project depeneding on some KPI’s. Then calculate avg of that

Thanks, I’ll give that a try.