Forum Discussion

veranceftw's avatar
veranceftw
Icon for Helper II rankHelper 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 re...
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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
veranceftw
Icon for Helper II rankHelper II
6 years ago

Icey , thanks for your help, much appreciated 🙂

 

Here is the pbix file! Thank you

 

Kind regards,

 

Luís

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    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.