Forum Discussion
Average processingtime per ticket state / Measure required
Hello everybody, I've got an problem creating a report for showing the average processing time for several tickets based on a processing table which includes each state for each ticket and the ne...
Hi Cypher294,
To use the measure.
Measure = CALCULATE(SUM(Sample_Data[Time in Hours]))/CALCULATE(DISTINCTCOUNT('Incidents 2'[Incident ID]),ALLEXCEPT('Date','Date'[Date].[MonthNo]))
Regards,
Frank
HI v-frfei-msft,
it looks well so long... But I have one more issue which cause currently some problems.
Normally not every ticket ID which is recorded in " Incidents 2 " is recorded in "Sample_Data" which cause some problems.
It divides by all the unique IDs recorded to Incident 2 table not just by the ones registered in BOTH.
If I adjust the measure ( page 2 --> Measure 2 ) It counts right for "Group" seperation but not for "State".
I've uploaded an adjusted sample data. Hopefully this is the last problem to be solved ...