Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I'm trying to calculate the open rate for email messages based on the following data. How would I create a measure that divides emails opened/emails sent?
Feature | Month | Total |
Emails sent | April | 1000 |
Emails Opened | April | 100 |
Solved! Go to Solution.
Percentage =
var _sent = Calculate (Sum(Table[Total]), Filter(ALLExcept(Table,Table[month])), Table[Feature]) = "Email sent")
var _open = Calculate (Sum(Table[Total]), Filter(ALLExcept(Table,Table[month])), Table[Feature]) = "Email opened")
Return
Divide(_open,_sent)
Hi @Anonymous ,
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
@Anonymous
Measure =
DIVIDE(
CALCULATE(SUM(Table[Total]), Table[Feature] = "Emails Opened"),
CALCULATE(SUM(Table[Total]), Table[Feature] = "Emails sent")
)
Percentage =
var _sent = Calculate (Sum(Table[Total]), Filter(ALLExcept(Table,Table[month])), Table[Feature]) = "Email sent")
var _open = Calculate (Sum(Table[Total]), Filter(ALLExcept(Table,Table[month])), Table[Feature]) = "Email opened")
Return
Divide(_open,_sent)