Forum Discussion
Giada_Togliatti
Post Patron
Post Patrontotal in average weight
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 ...
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
Advocate I
Advocate ISince 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 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