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.
amitchandak
Super User
Super UserBieBel , This need correct for total =
Total days = Sumx(
SUMMARIZE('Closed_Tickets_Filtered',
'Closed_Tickets_Filtered'[WR_ID],
'Closed_Tickets_Filtered'[MONTHCOMPLETED],
'Calendar'[Month], "_days", [Netto_Workdays_per_month ]
), [_days])
Use the correct group by at the month level, employee level
BieBelHelper I
Helper IHello amitchandak,
I do not see what the "_days" is in your formula? Could you please elaborate on this?