Forum Discussion

aykim101's avatar
aykim101
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Sum 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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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.