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
|Projects||Count||Percent of Total||Average Score||Weighted Score|
|Need to get 2.8 NOT 2.95|
|I get this||2.95||=100% * 2.95|
Assuming these are measures, you generally have to use an IF statement coupled with a HASONEFILTER statement to calculate the measure one way versus another for the individual rows versus the total row.
Proud to be a Datanaut!
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]
thank 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
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.
Have you worked it out? If so, would you please kindly mark the corresponding reply as an answer? If not, please feel free to ask.
What I meant "Add a calculated column" is creating a column rather than measure.
Could you please teel me in your scenario, whether above fields [Count], [Percent of Total], [Average Score] and [Weighted Score] are columns or measures?