Forum Discussion

Cypher294's avatar
Cypher294
Frequent Visitor
7 years ago

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...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Cypher294,

 

To update the measure as below.

 

Measure = CALCULATE(SUM(Sample_Data[Time in Hours]))/CALCULATE(DISTINCTCOUNT(Sample_Data[Incident ID]),ALLEXCEPT(Sample_Data,Sample_Data[Date].[MonthNo]))

 

Regards,

Frank

Cypher294's avatar
Cypher294
Frequent Visitor
7 years ago

Hi v-frfei-msft,

 

I Thought I could adapt the sample data to my real database table environment with all relations etc. but if I use the statement within this environment the calculation seems to be faulty.

 

I've attached a new pbix and seperated and relate the tables like they are in real.

 

The calculation with the seperation by team seems to be correct on a monthly basis but if I use the same measure to separate by state it seems not. The expextation is that the 77+58 ( sum by team = 135  ) will be distributed by the states but currently the sum is bigger than 135.

 

Maybe you could help again.

 

Thanks for your great support it helps me a lot.

 

Sample 3