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...
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] )
    )
)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper 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