Forum Discussion
Weighted Average for Multiple Variables by One Other Variable
I went back to my data set and re-did the formula and it still wasn't right with my slicers but I realized it was a bad connection in my web. I was able to fix it! This formula does work even with the long table. Thank you!
The measure you gave looks right to me for a weighted average calc. I broke it into 3 just to look at the values.
Weighted Values = SUMX('Table', 'Table'[Values] * 'Table'[#value])Total Weight = SUM ('Table'[#value])Weighted Average = DIVIDE([Weighted Values],[Total Weight])
What are you expecting to see that is different from the output?
Yes those weighted averages at the end are right (just not percentages). I am looking to have one final weighted average for each category. The output bar chart would look like below. I just did the weighted averages in excel and created a chart. This is what I need to accomplish. The formula works for each one individually in the first table I posted but that's a lengthy process. It's not working to produce the correct % when I do it on the pivoted table since those #values are duplicated 4 times.