Forum Discussion
Solved
total 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:
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: