Calculating time/ days for each activity in a process based on a critertira from another column

Hi,

Thank you for your comment! But I can’t still understand this – now I have this table showing different transactions on each of the booking number. Each of the booking number is related to a department and I want to see the average time it takes to complete a booking. If I filter the measure as it is on Booking number it gives me the right number of days per booking, however, on an aggregated level it does not work. From the below table, I cannot see how the measure can give me the average numbers per booking or per Department. Any suggestions how to modify the measure? Or do I have to use calculated column to solve this?

Dep.Booking nr.TransactionTimestamp

The measure gives this result (which is correct) - but how do I find an average on an aggregated level? e.g. how to find the average pr booking number or average per department?

Regards

Amund