Open Count

Hi, Been lurking around the forum looking for an answer but I cannot figure it out. I need to calculate # of open cases - a backlog of cases that is carried over from previous day. I have my mai...

Need Help

Tips and Tricks

Tutorial Requests

Anonymous

3 years ago

Hi StoryofData ,

I update your measure and get the correct result.

Cases Still Open = 
CALCULATE (
    DISTINCTCOUNT ( 'Query1'[CaseNumber] ),
    FILTER (
        'Query1',
        (
            'Query1'[DateOpened] <= MAX ( 'Time Period Daily'[Full Date] ) 
                && 'Query1'[DateClosed] > CALCULATE ( MAX ( 'Time Period Daily'[Full Date] ) )
                || 'Query1'[DateOpened] <= CALCULATE ( MAX ( 'Time Period Daily'[Full Date] ) )
                    && ISBLANK ( 'Query1'[DateClosed] )
        )
    )
)

Result is as below.