Sum working time over Total available time

[T-Pan]

In my data set i have two date/time columns which i've subtracted and created a new column "handling time in seconds" which represents the duration in second for an employee to solve a case. In a day there will be several cases per employee (i meam rows in the same date). Also i have created another column "available time" where i've 28800 as a whole number (the available seconds per working day). I want to measure the percentage difference of total Handling Time "Sum(Handling time in Seconds)" over "total available time" = sum(available Time) .

When i try to visualise this on matrix for a month - day, if in a day there more than one case gives me wrong the sum available time because it is multiply 28800* cases.

[Anonymous · Accepted solution]

HI @T-Pan,

It seems like a common issue when measure expression to calculate with multiple aggregations.

For this scenario, I'd like to suggest you take a look at the following blog to know how to handle it:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[amalsperera]

Hi @T-Pan ,

Please post some sample data or the pbix.

Amal