Forum Discussion
Helper IIMeasure won't sum up
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.
Community SupportHi 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.
Helper IIThat measure is returning NaN for me
- Icey
Hi veranceftw ,
If the measure I provided doesn't work, please share me your .pbix file to help you better. Please remove sensitive information and unnecessary visuals. It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
- veranceftw
- Icey
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.