Forum Discussion

StoryofData's avatar
StoryofData
Helper III
2 years ago
Solved

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's avatar
    Anonymous
    2 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.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.