Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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
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
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
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |