topic Cases open on particular day, plus opened and closed in DAX Commands and Tips

Cases open on particular day, plus opened and closed

Cuggers7 — Wed, 01 May 2024 06:10:01 GMT

Hi There, I am trying to create a graph on a table of incidents where I can see a history of how many incidents we had open on a day, but also how many were closed/opened. I have tried some similar ones on this community but none seem to work.

Thanks.

Re: Cases open on particular day, plus opened and closed

AntrikshSharma — Wed, 01 May 2024 07:04:15 GMT

Cuggers7 https://www.daxpatterns.com/events-in-progress/

Re: Cases open on particular day, plus opened and closed

Cuggers7 — Thu, 02 May 2024 01:28:03 GMT

Hi there, I am not getting a result with this dax =, how should i configure the relationship to the date table? do i use would i use time opened or time closed?

Re: Cases open on particular day, plus opened and closed

Anonymous — Mon, 06 May 2024 10:05:45 GMT

Hi Cuggers7

I’d like to acknowledge the valuable input provided by the AntrikshSharma . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the case.
In my investigation, I took the following steps:

My sample:

New calculated table:

Relationship:

Create two measures as follow:

Open = CALCULATE(COUNT('Table'[Time Opened]), USERELATIONSHIP('Table'[Time Opened], 'Date'[Date]))

close = CALCULATE(COUNT('Table'[Time Closed]), USERELATIONSHIP('Table'[Time Closed], 'Date'[Date]))

Final Output:

If this sample data is structurally different from the one you are using, please do not hesitate to mention it and I will modify it.

Best Regards,
Yulia Xu

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