Cases open on particular day, plus opened and closed

[Cuggers7]

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. 

[Anonymous · Accepted solution]

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.

[Cuggers7]

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?

[AntrikshSharma]

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