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.
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.
Thanks Miguel, this is just what I needed.
Happy new year.