Forum Discussion
Add backlog value before calculate
Good morning I'm trying to calculate a ticket backlog starting at 01/01/23, with open ticket, closed ticket and balance.... everything is ok for that, there are various examples .... My problem...
With the Data ....
I would like to add 120 to my starting backlog
Tickets Créés = CALCULATE(COUNT('DataRM_GIDN'[TicketRM]),USERELATIONSHIP('DataRM_GIDN'[Créé],'TBCal'[Date]) )
Tickets Cloturés = CALCULATE(COUNT('DataRM_GIDN'[TicketRM]),USERELATIONSHIP('DataRM_GIDN'[Fermé],'TBCal'[Date]),not(ISBLANK('DataRM_GIDN'[Fermé])))
Backlog =
CALCULATE(
COUNTx(
FILTER(
'DataRM_GIDN',
'DataRM_GIDN'[Créé]<=max('TBCal'[Date]) && (ISBLANK('DataRM_GIDN'[Fermé])
|| 'DataRM_GIDN'[Fermé]>max('TBCal'[Date]))
),
('DataRM_GIDN'[TicketRM])
),
CROSSFILTER(
'DataRM_GIDN'[Créé],'TBCal'[Date], None
)
)