Forum Discussion

Pan_Forex's avatar
Pan_Forex
Helper III
3 years ago
Solved

Population average from average

Hello, I try to count the average based on another average. My first measure is simple. It simply counts the average of the last 60 games for each player. Unfortunately it only works when you add two...
  • AnthonyGenovese's avatar
    AnthonyGenovese
    3 years ago

    I would do something like below. Basically,. that table you created in your model, you create in memory in the measure, and then itterate over that to get your average. I guessed at where your players table comes from so you will need to change the table and column names as needed.

     

    var tab1=SELECTCOLUMNS('public random_players', "Players", 'public random_players'[players], "playerAverage", [Average 60])
    var result = AverageX(tab1, "playerAverage")
    return result

     

    If this post was helpful, please kudos or accept the answer as a solution.
    ~ Anthony Genovese
    Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

AnthonyGenovese's avatar
AnthonyGenovese
Resolver III
3 years ago

So to clarify, you want to take an average over the list of players and their average_60?

 

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!