Calculating Average Engagement Rate Per channel

[AW31]

I'm attempting to create a column/measure that shows average engagement rate per athlete. I already have a measure for engagement rate included in the post section, but I'm having trouble writing the correct calculation for it. My relationships are included below. My ideal scenario would be to have a column in the athlete section called "athlete engagement rate".

The data is social media posts from athletes. Along with displaying the engagement rate of each post like I have already, I also want to show the average engagement rate for that channel to show if the post is performing better or worse than expected. I've attempted a few different calculations but end up getting the same input as Post Engagement Rate. It is also a direct query so I've received the "does not work with direct query" prompt as well. Any suggestions? I can include more data/examples if needed. Thanks!

[v-eachen-msft]

Hi @AW31 ,

You could refer to the following measure:

Measure 2 =
AVERAGEX ( ALLEXCEPT ( Table, Table[Handle] ), [Engagement Rate] )

[AW31]

I will try this. Thank you!

[v-eachen-msft]

Hi @AW31 ,

You could accpet replies you like if your questions have been solved.

[lc_finance]

hi @AW31 ,

are you able to upload a sample of your pbix file to DropBox, One Drive, Drive or similar and then include a link to it?

That will help in understanding your goals.

Also please include an example of what the column 'athlete engagement rate' should show.

Regards,

LC