Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
fetster
Frequent Visitor

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

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? 

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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
    )
    

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@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
    )
    

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.