Dividing a fixed number by a calculated number

[JayPow28]

Hi,

I have table with a number of columns, one is a list of employee names and another is a list of the hours those employees are contracted to per week, for example John Doe 40 Hours.

I also have a column in another table that is summing up the total billable hours for the employees each week.

In my report I can see the employee name, normal work hours and what has been billable for that week,

John 40 (Hrs) 32.5 (billable)

I want to divide the billable time by the weekly hrs to get a percent billable based on their contracted hours.

How can I do that?

Most examples I see try to SUM the work hours, but I don't need that.

Regards,

Jason

[BA_Pete · Accepted solution]

Hi @JayPow28 ,

Without seeing your data it's a bit more difficult, but I guess it would be a measure something like this:

_yourMeasure =
DIVIDE(
  SUM(tableA[billable]),
  MAX(tableB[contractHours]),
  0
)

This assumes that tableA and tableB are related via a common dimension (probably employee) that is used in your visuals.

Pete 

[JayPow28]

Briliant, thanks Pete.

That worked!

Much appreciated,

Jason

[BA_Pete]

No problem Jason. Happy it worked for you 🙂

[JayPow28]

Thanks Pete, that looks exactly like I was looking for.

It was the MAX function I was missing.

I'll try it out later and let you know, thanks for the help.

Jason