Forum Discussion
Weighted Survey Total
Hi all, I've got 3 measures of percentages.
How can I combine these data sets but with a weighted total. The best example I can think of is kinda like how a grade is calculated in a classroom. These values are all held in their own measure. (also made the commerical scores really bad since usually they're all about the same but wanted to make sure that its caluclated correct.)
How can I create a measure to display the percentage that the online caluclator displayed?
Was overthinking it. Figured it out by using this formula.
averageOfAll = CALCULATE( 'SQL Survey'[Assessment Satisfaction %] *0.35 + 'SQL Survey'[Bundle Satisfaction %] * 0.35 + 'Survey Tracker'[CommcericalAverage] * 0.30 )Something else that kept screwing me up was it was using all historical data which becomes invalid at somepoint and kept screwing up the formula. Had to filter by 2 timestamps and its working exactly as expected
2 Replies
Was overthinking it. Figured it out by using this formula.
averageOfAll = CALCULATE( 'SQL Survey'[Assessment Satisfaction %] *0.35 + 'SQL Survey'[Bundle Satisfaction %] * 0.35 + 'Survey Tracker'[CommcericalAverage] * 0.30 )Something else that kept screwing me up was it was using all historical data which becomes invalid at somepoint and kept screwing up the formula. Had to filter by 2 timestamps and its working exactly as expected