Total Bookings (all time) made by customers visiting on specific date

[fetster]

Hi,

I have a Bookings Table that shows all bookings including EmailAddress of customer and the dates the customer has booked for.

I want to be able to select a specific day in a date slicer and see the email address of all customers booked in for that day along with the total number of bookings they have made since we started the system (count of EmailAddress). 

I'm not sure how I can do this as when I use the date slicer it only shows the bookings for that date and count of EmailAddress is always only showing 1 (for the booking on the selected date). 

Any ideas how I can do this please? 

[Fowmy · Accepted solution]

@fetster 

You can use this measure to show the count of email address as of selected date from the beginning 

Measure = 
var __CurrentDate = MAX(Customers[Date]) Return
CALCULATE(
    COUNTROWS( VALUES( Customers[EmailAddress ] ) ),
    Customers[Date] <= __CurrentDate
    )