Measure to find how many products have been booked

[LaurenceSD]

Hi, 

I have a list of Hotels and List of bookings, I want to find a masure to calculate how many of those hotels have been booked.

My Measure for number of hotels is 

Enabled Hotels = COUNTROWS(Hotels)

My measure for Hotel Bookings is 

HotelBookings = DISTINCTCOUNT(HotelBkg[BookId])

How can I create a new measure to filter down to only those that have had a booking, in whatever date period is selected by the end user?

Thanks

[Prabhat · Accepted solution]

HotelCounts = Calculate(Count(hotes),filter(Table,table'BookingID"<>Blank())

[LaurenceSD]

Works perfectly, thank you

[mh2587]

Please share your sample data