Forum Discussion

Calumc12's avatar
Calumc12
Helper I
6 years ago

New Measure

Hello,    Im currently looking into some analysis - for reference this is for a sports team. I am trying to simply look at a % of how much a training session was worth compared to a competitive gam...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Calumc12's avatar
Calumc12
Helper I
6 years ago

Hi Pranit

 

I dont know how I can be more clearer there. I have data collected in a sports training session. I want to compare that data to average data per position from a game and present as a % off grand total 

for example from the information collected show what percentage players have ran in training compared to a game

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

Calumc12 

It would be really helpful (for us to help you in turn) if you could provide sample data, a representation (do it it in Excel if need be) of the expected result and if possible, a sample PBIX file to work with.

otherwise we are just guessing!

thanks!

  • Calumc12's avatar
    Calumc12
    Helper I
    6 years ago

    Yeah, totally apprieciate that 

    I think I have cracked it. I have manaaged to create a relationship between the player positions so Power BI finds the average per position and not on all of the data - i am just double checking this manually in excel to see if it returns the same data. 

    i will post once complete

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi Calumc12 ，

       

      Is your issue solved now?

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!