Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Pan_Forex
Helper III
Helper III

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 columns(player, Average_60) in the visualization

Average_60 = 

VAR _score = AVERAGEX (TOPN (60,'public random_players','public random_players'[game_id]), 'public random_players'[game_score])

return  _score

Any way to count the population average based on each player's final scores from Average_60?

1 ACCEPTED SOLUTION

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!

View solution in original post

3 REPLIES 3
Pan_Forex
Helper III
Helper III

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 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
Resolver III
Resolver III

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!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors