Forum Discussion
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 re...
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.
Hi veranceftw ,
For the value in the second table, it first calculates the sum of each teams of the two columns separately, and then divides the two sums. For example, the value 3.99 is calculated like so:
Pressure Final 3rd p90 Manchester City =
CALCULATE (
SUM ( all_match_stats[pressures_att_3rd] ),
all_match_stats[team_name] = "Manchester City"
)
/ (
CALCULATE (
SUM ( all_match_stats[minutes] ),
all_match_stats[team_name] = "Manchester City"
) / 90.0
)
It is suggested to create another measure to get sum value:
Measure = SUMX('all_match_stats',[Pressure Final 3rd p90])
I create a simple example, please check the attached .pbix file.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That measure is returning NaN for me