calculate percentage

[Anonymous]

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

[harshnathani]

Hi @Anonymous ,

Measure =

var _sent = Calculate (Sum('Table'[Total]), Filter(ALLExcept('Table','Table'[month]), 'Table'[Feature] = "Emails sent"))

var _open = Calculate (Sum('Table'[Total]), Filter(ALLExcept('Table','Table'[month]), 'Table'[Feature] = "Emails Opened"))

Return

Divide(_open,_sent)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[az38]

@Anonymous 

Measure = 
DIVIDE(
CALCULATE(SUM(Table[Total]), Table[Feature] = "Emails Opened"),
CALCULATE(SUM(Table[Total]), Table[Feature] = "Emails sent")
)

[harshnathani · Accepted 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)