Forum Discussion

dylen's avatar
dylen
Regular Visitor
2 years ago
Solved

How to find occupancy percantage

Hi,    I am trying to show our Occupancy total as a number and as a percentage.  Ideally I would like to replicate this formula from excel but no luck = IF(Operational places>0,(1-(Vacancies/Opera...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi dylen - Create below measures as may be if you want to show occupancy count use the first measure and for percentage occupancy use the second measure :

     

    Measure 1: Occupancy Number = IF(SUM('Table'[Operational places]) > 0, (1 - (SUM('Table'[Vacancies]) / SUM('Table'[Operational places]))), 0)

     

    Measure 2: Occupancy Percentage = IF(SUM('Table'[Operational places]) > 0, (1 - (SUM('Table'[Vacancies]) / SUM('Table'[Operational places]))), 0) * 100

     

    use format, to display the values in percentage.Now it is possible to display the percentage occupancy 

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi dylen - Create below measures as may be if you want to show occupancy count use the first measure and for percentage occupancy use the second measure :

 

Measure 1: Occupancy Number = IF(SUM('Table'[Operational places]) > 0, (1 - (SUM('Table'[Vacancies]) / SUM('Table'[Operational places]))), 0)

 

Measure 2: Occupancy Percentage = IF(SUM('Table'[Operational places]) > 0, (1 - (SUM('Table'[Vacancies]) / SUM('Table'[Operational places]))), 0) * 100

 

use format, to display the values in percentage.Now it is possible to display the percentage occupancy 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!