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:

     

derrick777's avatar
derrick777
Advocate I
5 years ago

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'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