Hotel occupancy rates

I don't know if sdjensen is correct. Every company has its own metrics and there may be a reason to go with the formula as originally given. But I do like the way he's thinking. So just for fun here's that version:

Oh wait, before that, things would be easier if the OccupancyTable had a unique index column. I've named it ReservationID. Also if you have room status like I described earlier, you should change the part that says ALL(RoomTable) to FILTER(ALL(RoomTable), RoomTable[Status] = "Active") or whatever fits your actual status options. OK now here's the measure:

Occupancy Rate = DIVIDE(
	SUMX(
		FILTER(
			OccupancyTable,
			OccupancyTable[Date_from] <= LASTDATE(DateTable[Date]) &&
			OccupancyTable[Date_to] >= FIRSTDATE(DateTable[Date])
		),
		COUNTROWS(
			DATESBETWEEN(DateTable[Date], OccupancyTable[Date_from], OccupancyTable[Date_to])
		)
	),
	(CALCULATE(
		DISTINCTCOUNT(RoomTable[Room_ID]),
		ALL(RoomTable)
	) * DISTINCTCOUNT(DateTable[Date])
	)
)

As usual you can always subdivide this into several measures for portability and readability. Here's a test file to play with. It just has that most recent measure in it because it's the only one I couldn't error-check in my head. :P

Vvelardeyeah I agree with that. If one room were never occupied it would never be counted using that original formula unless you had that separate table. But it sounds like that's covered in any case.