Forum Discussion
Occupancy Rate Formula
Solution to the problem
Use the following formula to count the number of selected options in the slicer.
Also check this video: https://www.youtube.com/watch?v=D532_ix9qLQCount Selected Properties =COUNTROWS(VALUES( 'Properties'[Accommodation] ))
Replace the red bold text with the field you added in your slicer. So this will count how many options you have selected and if there is no option selected will count all the number of options in the slicer.
Then add this in your occupancy formula to multiply it with the number of days.
This is my formula because we manage properties that we allow owners to block dates for their own use of the property and we want to remove those days from the total days that the property was available.Occupancy Rate =[Total Rented Days] / ( (365* [Count Selected Properties])- [Total Blocked Dates])
This will return you the right result. It will be off by one day for leap years personally but for me that is negligible.
Use a proper calendar table so you can use the actual days in a year (including THIS year!).
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523