Forum Discussion

PANNEER's avatar
PANNEER
Frequent Visitor
9 months ago
Solved

occupancy & churn rate

Hi Friends, Currently I'm working on Agreements Dashboard in power bi. what is the churn rate and occupancy rate dax formula for agreements dashboard? can anyone provide me the solution for this?
Need Help
rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
9 months ago

Hii PANNEER 

 

Churn rate and occupancy rate depend on how your agreements table is structured, but the standard formulas in Power BI are:

  1. Occupancy Rate
    Percentage of active agreements vs total capacity.
Occupancy Rate =
DIVIDE(
    CALCULATE(COUNTROWS(Agreements), Agreements[Status] = "Active"),
    CALCULATE(COUNTROWS(Agreements))
)
  1. Churn Rate
    Percentage of agreements that ended during the selected period.
Churn Rate =
DIVIDE(
    CALCULATE(COUNTROWS(Agreements), Agreements[EndDate] <= MAX('Date'[Date])),
    CALCULATE(COUNTROWS(Agreements), ALL(Agreements))
)

These are the most commonly used KPI definitions for agreement dashboards.