Here is how to calculate weighted average using DAX in Power BI. By creating a measure that calculates the weighted average, you can get results by necessary category.
Tag: DAX weighted average per category
Calculate weighted average in Excel PivotTable in 2 ways
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as a weighted average by using calculation in an Excel worksheet. The good news is that you can use that method to validate your results.