Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
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?