Forum Discussion
Calculate Percentage
Hi All, I'd love some help with calculating percentages for a booking system please. I want to calculate the percentage of appointments booked / room capacity, per room, per day, in order to show...
Only based on the information you provide can you create the following measures:
Total appointments = SUM(Rooms[Total Appointments per day]) Ocupation = DISTINCTCOUNT(Schedule[Appointment ID]) Room availability = SUMX(Rooms,[Total appointments] - [Ocupation]) % availability = [Room availability] / [Total appointments]Create a different measure to have the step layout now just use the ones you need in your visualization:
Note that your information is very small if you need other requirements, share a sample file and the expected result.
Where you're unclear is how long are appointments. Are they a standard allotment of time or do they have individual start and end times? Without knowing that this is impossible.