New Measure

[Calumc12]

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

I have done this by creating two data files in excel. One is my 'match analysis' (the data collected in competition), the other is my 'training data' (data collecting in training sessions. 

I have investigated this and used the AVERAGE function i.e the measure I want to compare is total distance ..

total diatance % = AVERAGE ( 'training data' [total distance]) / AVERAGE ('match data' [total distance])

this formula works although, it does not give me the data I need. I need to expand upon this and be more specific; I have ten players in this example, who play different positions. I want to criteria match the position to the player so I would return a value that would give me the % between training and match data for that position/player. 

a littlw more context, within my data sheets made in excel, I have a VLOOKUP formula which uses the same positional criteria i.e player 1, stricker so all formatiting and spelling would be the same.  Any help from you wizzards would be greatly appreciaited 

CC

[pranit828]

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]

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]

@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]

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]

Hi @Calumc12 ，

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!