Forum Discussion
aykim101
Microsoft Employee
Microsoft EmployeeSum Total Row based on Weighted Average values above it
Trying to sum the values of a weighted average column using the records above the "Total" row I can only get the Total Row to use the same weighted average calculations as the rows above it P...
v-yulgu-msftMicrosoft Employee
Microsoft EmployeeHi aykim101,
For 'Average Score', you could create a measure like:
Average Score = AVERAGE(Sheet1[Score])
For 'Weighted Score', you could create a calculated column like:
Weighted Score Col = Sheet1[Percent of Total]*[Average Score]
Best regards,
Yuliana Gu
aykim101Microsoft Employee
Microsoft Employeethank you for the reply
that is the logic being used; however the "Total" row needs to sum the row values above it and NOT use the same Weighted Score calculation
- v-yulgu-msft
Hi aykim101,
If you add a calculated column into table visual and enable the total row, the "Total" row will sum the row values above it automatically.
Regards,
Yuliana Gu