Forum Discussion

Giada_Togliatti's avatar
Giada_Togliatti
Post Patron
5 years ago
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 ...
Need Help
  • ekoland88's avatar
    ekoland88
    5 years ago

    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:

     

Giada_Togliatti's avatar
Giada_Togliatti
Post Patron
5 years ago

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

 

derrick777's avatar
derrick777
Advocate I
5 years ago

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

  • Giada_Togliatti's avatar
    Giada_Togliatti
    Post Patron
    5 years ago

    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