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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Calumc12 

Can you please provide input and required output in table format for the community so that you ask can be better understood and resolved quickly.

  • 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