PowerPivot DAX: Identify running cases over time per items/cases

Hi Bhavesh,

Thanks for your quick answer. I tried your measure but unfortunately it's not the desired result.

If you see the transaction table after 4 days of activities (in date of 8th of December), the result should be 3.

For all the period we still have 3 running cases. The others cases are all closed (not running)

The measure have to consider (count) all the running cases that are less or equal to the current date of the evaluation contect.

The final aim for the team of Service Desk is to have an overview of all cases are still running over all the period --> What is left in the queue

This is the challenge for this measure :-). I tried different ways but I didn't get the desired result.

Tom