Engagement rate Measure

[Companyuser101]

Hello together, 

I want to calculate my engagement rate for my social media networks.

The formular looks like this:

((Interactions #1 / Follower#1) + ... (Interactions #x / Follower #x)) / Days 

So for example: We post on monday and gain 75 interactions. We have to divide this by the follower on that specific day. And we have to do this for all our interactions in a specific time period. Lets say for a week. Then we divide the sum by 7. 

I have problems to form the sum for the interactions divided by followers. Because you have to divide the interactions for the post by exactly the follower amount we had when we posted. 

Thanks for your help in advance!

[amitchandak · Accepted solution]

@Companyuser101 , Try a measure like

Averagex(Values(Date[Date]), calculate(divide(Count(Table[Interactions]), distinctcount(Table[Follower]) ) ) )

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Companyuser101]

Thank you, 

this helped me!