Forum Discussion
BieBel
Helper I
Helper ICalculations with measures return odd results
I work within an organisation which performs technical interventions and which is driven by a ticketing system. Now I need to calculate PRODUCTIVITY: the number of closed tickets per workingday. To...
Hi,
Share a dummy dataset to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Rufyda
Super User
Super UserHi BieBel
Use these two measures instead of the old formulas:
TotalDays =
SUMX(
SUMMARIZE(
'Closed_Tickets_Filtered',
'Closed_Tickets_Filtered'[WR_ID],
'Closed_Tickets_Filtered'[MONTHCOMPLETED],
'Calendar'[Month],
"NetDays", [Netto_Workdays_per_month]
),
[NetDays]
)
Then
Productivity =
DIVIDE(
[Closed_Tickets_per_Month],
[TotalDays]
)
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!