Forum Discussion
DAX Formula for Average Unique Email Open Rate
Hi, I am trying to figure out how to create a DAX formula for the average of another DAX formula. I already created a formula for showing the unique open rate: Open Rate = SUM(Combined_EmailG...
Hi Ibendlin,
Here is the data:
| Email Send Date | Content Type | Open Rate | Sum of Unique Opens | Sum of Total Delivered |
| 3/10/2021 21:00 | Tradeshow | 100.00% | 1 | 1 |
| 3/11/2021 22:00 | Tradeshow | 100.00% | 1 | 1 |
| 3/11/2021 23:00 | Tradeshow | 100.00% | 1 | 1 |
| 3/12/2021 13:00 | Tradeshow | 50.00% | 1 | 2 |
| 3/12/2021 15:00 | Tradeshow | 80.00% | 4 | 5 |
| 3/12/2021 16:00 | Tradeshow | 60.00% | 3 | 5 |
| 3/15/2021 11:00 | Tradeshow | 21.51% | 20 | 93 |
Thank you,
Chris