Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I am trying to calculate client engagement using a table showing clients and their employees who have taken action on marketing emails we send them. Actions include opening the email, clicking on a link in the email, accepting an invitation in the email, etc. I have a measure, [Engaged], that denotes an employee as TRUE if the employee took any of the tracked actions. I also have a measure, [Account Engaged], that denotes a client as TRUE if any of its employees took any of the tracked actions. It uses this measure I based on a post I found from 2017:
Account Engaged = CALCULATE(countrows('table'),'table'[Engaged]=TRUE)>=1.
Now I need to calculate the client engagement rate by dividing the total number of engaged clients by the total number of all clients. The screenshot below illustrates this scenario -- We have four clients, each with three employees. Employees at three out of the four clients have taken one or more actions on our marketing emails. Therefore, our engagement rate for our clients would be 75% (3 engaged clients/4 Total clients=75%). How can I calculate this Total Client Engagement percentage in Power BI?
Thank you.
Solved! Go to Solution.
Hi @mfaulk9258 ,
take a look at this.
Calculated Table:
Account Engaged = SUMMARIZE('Raw Data','Raw Data'[Client], "Engaged", CONTAINS('Raw Data','Raw Data'[Engaged],TRUE()))
Total True = CALCULATE(COUNTROWS('Account Engaged'), 'Account Engaged'[Engaged]=TRUE())
Total Client = COUNTROWS('Account Engaged')
True/Client = DIVIDE([Total True], [Total Client])
Hi @mfaulk9258 ,
take a look at this.
Calculated Table:
Account Engaged = SUMMARIZE('Raw Data','Raw Data'[Client], "Engaged", CONTAINS('Raw Data','Raw Data'[Engaged],TRUE()))
Total True = CALCULATE(COUNTROWS('Account Engaged'), 'Account Engaged'[Engaged]=TRUE())
Total Client = COUNTROWS('Account Engaged')
True/Client = DIVIDE([Total True], [Total Client])
That's it exactly and it worked perfectly. Thank you so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |