Row Totals

[Anonymous]

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. 

[Anonymous]

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

[Anonymous]

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 

[Anonymous · Accepted solution]

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.