Forum Discussion

veranceftw's avatar
veranceftw
Helper II
6 years ago
Solved

Measure won't sum up

Hello!

 

I have a measure that calculates the sum of a stat for every player. However, when I group those players as a team, instead of summig up all the measures for each player, it seems to be returning the average. How do I make it a sum?

 

Kind regards

 

 

 

 

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi veranceftw ,

     

    Sorry to reply late. 

    Please try to create a measure like so:

    Measure 2 = SUMX(VALUES(all_match_stats[player_name]),[Pressure Final 3rd p90])

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

10 Replies

    • veranceftw's avatar
      veranceftw
      Helper II
      6 years ago

      Like this:

       

      Pressure Final 3rd p90 = SUM(all_match_stats[pressures_att_3rd]) / (SUM(all_match_stats[minutes]) / 90.0)
      • az38's avatar
        az38
        Community Champion
        6 years ago

        veranceftw 

        maybe you need smth with SUMX()

        Pressure Final 3rd p90 = 
SUMX(all_match_stats,
SUM(all_match_stats[pressures_att_3rd]) / (SUM(all_match_stats[minutes]) / 90.0)
)

        but more correct and appropriate answer is possible if you provide more detail about your data model