Forum Discussion
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...
HI All,
Attaching the Image
The only measure I created for is Utilisation the others are pulling the data Directly from Tables.
J
It looks like the "Available Days" column is aggregating incorrectly. I plugged some of the sample data into an excel workbook at the grain I see in this table:
I then just used your model for Utilization:
Utilization = SUM(Sheet1[Days Rented]) / SUM(Sheet1[Available Days])
When I put all of this in a table, it looks correct on my end:
You can see in the image you provided that your Available Days only sums to 365, which is why your % value is so large. Is your data structured differently than what I provided above? Fixing how that value is summed is going to be the trick here I think.