total in average weight

[Giada_Togliatti]

Hi,

I have a column called average weight that is score*weight

On total of column score*weight I need to have the sum of score weight divided by the sum of weight  (5,20/1,40)= 3,71

This should work for each selection, how can I do?

Thank you

[ekoland88 · Accepted solution]

I did 4 measures:

_Score = SUM('test 2'[Score])

_Weight = SUM('test 2'[Weight])

Score Weight = SUMX('test 2',[_Score]*[_Weight])

Your Measure = IF(ISFILTERED('test 2'[Q ID]),[Score Weight],[Score Weight]/[_Weight])

The outcome:

[derrick777]

Since the total row is calculated the same way as the rows (just has another evaluation context), you cannot achieve exactly what you asked for. But you can create and show a measure which fullfills your requirements, like
Total Score*Weight := DIVIDE ( SUM ( 'Table'[Score*Weight] ), SUM ( 'Table'[Weight] ) )

[Giada_Togliatti]

@derrick777 , I've tried but it gives me a wrong result in all rows except total

[derrick777]

I thought this is what you want to achieve? Please define your requirements more precise.

[Giada_Togliatti]

@derrick777 , I need to divide only the total, what I need are these values:

1,20-0,9-1,50-1,20- 1,40 and total 3,71 but I don't know if it's possible to realize

[derrick777]

@ekoland88provided the solution