cancel
Showing results for
Did you mean:
Helper I

## Help required diving individual hours by total billable hours.

Hi All,

Refer below screen shot : I want to divide hours/Amount : 156  with billable hours(measure) 160.50 and expecting client utilization has .971 and similarly 4/160.50 and expecting .028, but right now it is dividing row by row giving 1. Please help me dividing billable hours total (160.5) by individual hours.

1 ACCEPTED SOLUTION
Super User

Can you test your variable, to see what it returns.

In the formula after RETURN replace the divide function and all its argument, by the name of the variable you want to test.

Check if CurrentEmployeeH and TotalHours are giving expected result.

`RETURNCurrentEmployeeH `

then same with Totalhours. Let us know

7 REPLIES 7
Super User

Hi,

To get your usage percentage, you can do :

% by Employee =
VAR CurrEmployee =  [Employee]
VAR CurrentEmployeeH = CALCULATE( SUM([Hours Amount]) , [Employee] = CurrEmployee , ALL ( [Clients] ) )
VAR TotalHours = CALCULATE( SUM([Hours Amount]) , ALL (  ) )
RETURN
DIVIDE ( CurrentEmployeeH , TotalHours )

Hope it helps

Helper I

Thanks. I am unable to refer the Employee column in the sheet name utilization. Please refer below screenshot.

Super User

Make the change just on the 1st VAR, not on the line 3

Helper I

I am getting zero.

% by Employee =
VAR CurrEmployee = SELECTEDVALUE(Utilization[Employee])
VAR CurrentEmployeeH = CALCULATE( SUM(Utilization[Hours/Amount]) , (Utilization[Employee]) = CurrEmployee, ALL (Utilization[client names] ) )
VAR TotalHours = CALCULATE( SUM(Utilization[Hours/Amount]) , ALL ( ) )
RETURN
DIVIDE ( CurrentEmployeeH , TotalHours )

Super User

Can you test your variable, to see what it returns.

In the formula after RETURN replace the divide function and all its argument, by the name of the variable you want to test.

Check if CurrentEmployeeH and TotalHours are giving expected result.

`RETURNCurrentEmployeeH `

then same with Totalhours. Let us know

Helper I

I am getting below error now.

Super User

Hi,

Sorry, try SELECTEDVALUE([Employee]) instead of [Employee] for the VAR CurrEmployee, ie :

`VAR CurrEmployee=SELECTEDVALUE([Employee])`

Let us know

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors