Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to 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
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
141 | |
71 | |
70 | |
54 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |