Forum Discussion

Jazz_MT's avatar
Jazz_MT
Frequent Visitor
7 years ago

Calculating Utilisation Rate

Hi All,   I am trying to calculate a utilisation rate which has the following formulate: Utilisation  = Days Rented/Available Days       What I am finding funny is that for each individual...
Need Help
Jazz_MT's avatar
Jazz_MT
Frequent Visitor
7 years ago

Hi,

 

Out data model is different as it Counts the Rental Agreements in the Rental Agreements Granular table and based on the Month of the Rental PowerBI is obtaining the Available Days from the Date_table by counting the number of days in that particular month. 

 

Utilisation is basically being worked out as follows COUNT(Rental_Agreement)/COUNT(Rental_Date) i.e. Days Rented/DaysAvailable.

 

What PowerBI is counting the total number of the rows instead of summing the available days.

 

Thanks,

Jake

 

jtownsend21's avatar
jtownsend21
Responsive Resident
7 years ago

I believe I ran into the same issue using counts and it not aggregating correctly. Use your existing measure that works on a per row basis in a total function. See below:  

 

Utilization Rate = 
IF(
    HASONEVALUE('TABLE1'[Rental_Agreement]),
        [Existing Measure],
    SUMX(VALUES('TABLE1'[Rental_Agreement]),
        [Existing Measure]
    )
)