Weighted Survey Total

[GabeGap]

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?

[GabeGap · Accepted solution]

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

[v-yilong-msft]

Hi @GabeGap ,

Congratulations on solving your problem, I read your method carefully and found it to be effective. I think it can help other members on the forum.

Best Regards

Yilong Zhou