Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cummulative Count

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?

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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] )
    )
)

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Fowmy Sometimes the solution is too easy! I had a different x axis ðŸ˜¶

      Thanks for your help