Forum Discussion
Calculating Utilisation Rate
Jazz_MT cannot see the images, I assume these are measures you created. Do you have put any condition in the measure. Can you provide more details?
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.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
hi, Jazz_MT
This looks like a measure totals problem. Very common. See the post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Best Regards,
Lin
