Forum Discussion
Population average from average
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 resultIf 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!
Currently, the way I did it was to create a new table with Player and Average_60 columns. In my measure I simply refer to this table as the average of Average_60. However, I would like to do it all in one measure if possible.
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 resultIf 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!