Distinct Count By Group - Average
Hello, I am trying to find the unique open rate (count each email address once for each message it opens) for a set of messages. I can successfully see the unique open rate for each message stand alone; however when I try to aggregate it up to a set of messages it only count one email address ONCE (for all messages). Instead I want it to count that email address ONCE FOR EACH MESSAGE OPENED. I used this measure formula to determine unique open rate for each message (stand alone). U Open Rate = CALCULATE (DISTINCTCOUNT (Email_Activity[Recipient E-mail] ) , Email_Activity[Opened] = 1) / SUM(Email_Activity[Sent]) Just need some advice on how to get the aggrated (by each message) open rate. I figure there should be a GROUPBY() function or a SUMMARIZE function in there somehow. Please take a look at the photo below and thatmight make my question more clear (look at the highlighted and blue underlining).
