Forum Discussion
Dellis81
Post Prodigy
Post ProdigyWeighted Average
Hello - I am needing help with a weighted average calculate across multiple combination of categories. This is a first attempt, utilizing PBI quickmeasures - unfortunately only allows one category ...
You need to iterate at the lowest level of granularity for it to work properly at all levels.
In this case, you can iterate at the table row level to keep things simple.
Avg Moisture = DIVIDE ( SUMX ( 'Table', [SumMoisture] * [WetBushels] ), SUMX ( 'Table', [WetBushels] ) )Note that this gives 14% for both numbers circled. The value 20.87% makes no sense when all of the moisture measurements are below 16%.
Ashish_Mathur
Super User
Super UserHi,
How did you calculate the 20.87%?
Dellis81Post Prodigy
Post ProdigySorry, I was working off a spreadsheet, and had a transposed number. Appreciate your time - solution has been found.