Forum Discussion

Alain06's avatar
Alain06
Frequent Visitor
3 years ago

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 is that my balance was greater than 120 on 01/01/23 and I can't add that to my automatic calculation

 

Can you help me

Need Help

1 Reply

  • Alain06's avatar
    Alain06
    Frequent Visitor
    3 years ago
    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
        )
    )