Forum Discussion
Solved
Weighted Average for Multiple Variables by One Other Variable
So I have multiple values in columns that all get weighted by one other value to get the weighted average for each. Easily accomplished in SPSS by weighting the data set. Sure I could run the weighte...
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!
No, this measure works fine also.
Weighted Average 2 =
DIVIDE(
SUMX('Table', 'Table'[Values] * 'Table'[#value]),SUM('Table'[#value])
)I just created the 3 to see the values at each step.
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!