Calculate team/employee utilization for drilldown?
Hi! I need to prepare an employee utilization report (preferably drill-downable), which should show following data: 1. Utilization per business area 2. Utilization per team (multiple teams in each business area but not cross-areas) 3. Utilization per single person (and unfortunately, some people are present in more than one team, some of them even participate in teams from different business areas...) Utilization is calculated classically as: billable time divided by entire time logged in a timesheet by a an employee (followed by aggregated time calculations for teams and business areas). My question 1 is: can it be done autimatically or do I have to prepare a separate table with calculations for each of the 3 levels? And if I need to make it through the tables - question 2: will it be possible to prepare drill-down report that way? I am pretty new to PowerBi, I tried to search for information on some neat way to make without additional tables but did not find any that I could use. I will appreciate an answer - even if it is: make those **bleep** tables & sorry, no drilldown 😄
Calculate UsageTime per Day
Hello, I'm new to Power BI and need your help: I have a table with licenese and now I want to calculate their Utilization per Day. There are 2 licenses(BIE-WV414 and BIE-WV450) with licenseStart time and licenseEnd time, per day there are many licenses started and finsihed. I also have calculated the usagetime (in total). The problem is some of the licenses are used longer than 24 hours or past midnight. (See Screenshot). Now i want to calculate and display the usage time of each license per day. For example for the first line: 1.10 BIE-WV414 aprox. 22h 2.10 BIE-WV414 24h 3.10 BIE-WV414 aprox. 7min Regards, Jani
DAX to Calculate Room Utilization by Hour and Day
Hi PBI Community, I'm trying to calculate hourly % utilization with a sample of the following data points. I want to display a matrix visual that shows by day and hour, the percentage of rooms occupied (similar to the last image). I found this DAX on this site but couldn't get it to calculate correctly. I also need to ensure that the appropriate utilization is calculated for the hours inbetween "In" and "Out." For instance, if 'In' is 8am and 'Out' is 10am, I need to make sure that the DAX accounts for the 9am hour. Sorry -- new to DAX and looking to learn from the community. _______________________ Measure Utilization = var _occupied = CALCULATE(COUNT('Source'[Guest]), FILTER(ALLSELECTED('Source'), 'Source'[In]<=MAX('Table Time'[Time])&&'Source'[Out]>=MAX('Table Time'[Time])&&'Source'[Date]=MAX('Table Calendar'[Date]))) var _utilization = DIVIDE(_occupied,20) // for 20 rooms return IF(_utilization = BLANK(),0,_utilization)Unable to calculate the %Utilized (team,Individual)
As displayed in the attached Pictures trying to calculate TeamUtilization(%) and Individual Utilization(%) seperately only because when User is selected in the filter the utilization is not showing the same value. Technically utilization(%) = WorkedHrs/BillableHrs Perferably only 1 Measure with Utilzation(%) should work when deselected user it should show TeamUtilization and when selected it should show only that User utilization. DAX i used: Util% = [WorkedHrs]/[BillableHrs] TeamUtil% = [WorkedHrs]/([BillableHrs]*2)
