Forum Discussion
Divide values from two tables, dynamic required
Hi there, I've got a desk booking app and I'm trying to create the occupancy percentage, I want to do this by counting the number of desks at each site, in the Desks_MasterData table, then divide...
Hello,
Can you try:
VAR BookingsCount = CALCULATE(COUNT(Bookings[DateOfBooking]),ALL(Bookings))
And then OCC% = DIVIDE([DesksCount],[BookingsCount])
As you are trying to get the percentage so the denominator should not be affected by any filters.
I hope this works for you