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

veranceftw's avatar
veranceftw
Helper II
6 years ago

That measure is returning NaN for me 

Icey's avatar
Icey
Community 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
    Helper 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
      Community 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.