Create reference values, in measures or in tables to later use them to compare.

[sportdata]

Hello everyone. I am writing to see if anyone can help me.

Here is an image that can serve as a reference for my problem.

The following data shows GPS, training and game data, grouped by session (session_sess), it also shows the ID of each athlete (id_atlhete), and finally shows the name of each Drill (drill_gpsdata) that the Athlete performs in the sessions.

For example, in a game session, the Athlete participates in the 1st hf (1T) and 2nd hf (2T), and in a training session, he participates in several Drills as shown in the example (AQ.ESP.4X4+3, AQ. LU, TA.OP, etc).

What I'm looking for is based on this data.

1. Create a summary table of Games. where:

• a. First, the data of the variables of each drill must be added for each player. For example, if Athlete No. 3 participated in the                1st hf (1T), and the 2nd hf (2T), the table should add the data collected in each variable.
  b. Finally, create an average reference value of the variables for each player, and an average referential value for the entire team.
  c. Create a formula that allows comparing the result of a game with the referential value.

A big doubt is that unlike other models, here we have many variables, for each Athlete on each training day and that is why I don't know if it is best to take measurements or generate a complete reference table for all the variables.

I hope the explanation is clear, English is not my natural language but try to make it as simple as possible.

Atte.

Diego

[v-jialluo-msft]

Hi  @sportdata ,

Depending on your description, your need is to use measures to create data reference values that make it easy to compare data.
This requires you to provide sample data and expected output, which can solve the question faster.

If you don't know how to upload attachments, you can refer to the following links:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Gallen Luo