I'm still struggling with DAX commands but thanks to you guys I'm learning a lot and learning it fast too!
I've got a list with all the e-mail interactions per customer in it.
XYZ-number being a unique customerID
Mailing_ID being the unique e-mail campaignID
Interaction_type consists of three options: RECIPIENT, OPEN, CLICK
Basically this column tells when customers have received an e-mail, opened an e-mail or clicked an e-mail.
I need to create a seperate table having unique mailing_id's with a column showing the Total Opens.
How can I do this?