Cummulative Count

[Anonymous]

Hi Power BI Community!

I want to show the backlog of open to closed cases. 

Now the backlog just cummulative the open cases. I want the cummulative open cases - closed cases 

This is my measure:

Backlog = 
Count open - count closed

Backlog 1 =

CALCULATE ([Backlog],

FILTER (

ALLSELECTED ( 'QMeldung' ),

'QMeldung'[created] <= MAX ( 'Dates'[Date])))

Maybe the problem is that the open count measure has an different userealtionship then the closed count?

[Fowmy · Accepted solution]

@Anonymous 

Make sure you have inserted the Dates[Dates] in the X- Axis. try this calculation:

Backlog =

CALCULATE (
    [Count open] - [count closed],
    FILTER (
        ALLSELECTED ( 'Dates'[Date]),
        'Dates'[Date] <= MAX ( 'Dates'[Date] )
    )
)

[Anonymous]

@Fowmy Sometimes the solution is too easy! I had a different x axis 😶

Thanks for your help