Forum Discussion
Row Totals
I am trying to create get the totals from my WeightedScore column. The weighted score are correct nothing populating at the bottom. The "weightedscore" was a calculated field created in Excel before loading and is in the decimal number format and SUM summarization. Could someone please help me with building a seperate measure that will give me the total of my weighted score.
First picture shows that data and the columns.
This picture shows the fields I have and I am trying to get a total for the weighted score field.
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.
3 Replies
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.