My scenario is I am trying to show recipients of email newsletters and of those who opened the emails and for the newsletter type what percentage was their open rate i.e. A person could be sent 12 emails in a period and they read 6 so are in the 50% bracket, I then want to show that as a grouping of the percentage So, Group Never opened, G2 1 to 10%, G3 10% to 50% etc… I have tried following to the show case Segment Data Based on Percentage Groups - Advanced DAX In Power BI
I have created by report but I just can’t seem to get the grouping by % segments working right hopefully I have just done something silly.
If someone could take a look and tell me what a noob I am and how to fix it I will be very much grateful.
Newsletters.pbix (257.5 KB)