Forum Discussion
Row Totals
Hi Anonymous
You can use the following dax to create a calculate column:
Column = 'Table'[Score] * 'Table'[Points] * 0.01
If you want create a seperate measure that will give you the total of weighted score, please try the following measure and then put it into a card visual.Measure = SUM('Table'[Column])Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
Best Regards,
Jayleny
Course Name Score Points Attempts Name Weighted Score (score * point weight) Lesson 1 80 10 1 Jim Bob 8 Lesson 2 90 10 2 Tex Mex 9 Lesson 3 100 10 1 Jacki Chan 10 Lesson 4 87 10 2 John Doe 8.7 Lesson 5 70 10 1 Onna Fairway 7 Lesson 6 67 10 1 Geek Guy 6.7 Lesson 7 98 10 1 Skeeg 9.8 Lesson 8 40 10 1 Danny Downs 4 Lesson 9 78 10 1 Tex Mex 7.8 Lesson 10 90 10 1 Bad Worker 9 Lesson 11 90 10 1 Good Worker 9 Lesson 12 80 10 2 Onna Fairway 8 Lesson 13 90 10 3 Jim Bob 9 Lesson 14 80 10 1 Jim Bob 8 Lesson 15 70 10 5 John Doe 7 Lesson 16 89 10 2 Jacki Chan 8.9 Lesson 17 80 10 5 Tex Mex 8 Lesson 18 78 10 4 Danny Downs 7.8 Lesson 19 87 10 1 Good Worker 8.7 Lesson 20 98 10 1 Good Worker 9.8 Lesson 21 89 10 1 Chris Mendez 8.9 Lesson 22 77 10 2 Sherry Lien 7.7 Lesson 23 88 10 2 Onna Fairway 8.8 Lesson 24 99 10 2 Jim Bob 9.9 Lesson 25 60 10 2 Skeeg 6 Lesson 26 58 10 2 Skeeg 5.8 Lesson 27 0 100 1 Tex Mex 0 Lesson 28 0 50 1 Onna Fairway 0 Lesson 29 0 100 1 Geek Guy 0 Lesson 30 0 100 1 Geek Guy 0 Lesson 31 0 100 1 Tex Mes 0 This is a short version of what my data looks like. The weighted score is correct in the first image and as you can see even if the attempts are more than one it only takes the weighted score of the highest score. I am trying to get a total at the bottom that will show the weighted score. Anonymous
Hi Anonymous
You can use the following dax to create a calculate column:
Column = 'Table'[Score] * 'Table'[Points] * 0.01
If you want create a seperate measure that will give you the total of weighted score, please try the following measure and then put it into a card visual.Measure = SUM('Table'[Column])Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.