calculate weighted average

[eRic_LaU]

Greating All, 

I have a table and would like to caluate the weighted average, can Power BI work on that?

Secondly I have created a Matrix table by using visualizations, and put a Average of Rating as the values, but I found that the total value also in averaged can it change into sum of total? the ans prefer to be 100%

Looking for someone help, thanks a lot.

[oritam3210]

Hi @eRic_LaU,

You can calculate the weighted average by using the AVERAGEX function.

The basic formula for this function is

AVERAGEX( TableName, TableName[Mark] * TableName[Rating] )

Regarding the total, this new calculation might resolve the issue.

Alternatively, you can choose to hide the total line if necessary.

Good Luck

---------------------------------------------------------------------------------------------------------------------
If you find this helpful, kindly consider marking it as 'Accepted Solution.'
This action helps others quickly find a reliable answer!