Forum Discussion
Solved
Filter the tickets which have the same opened/closed date
Hi guys!! Today I can filter (closed tickets or opened tickets) in my tickets system by the date using two separated measures. I'm not able to get tickets which have the same date/period of "Open...
Hi everyone!!
Finnaly, I got this problem resolved on my own!! If someone is facing this problem, I share the solution that I figured out:
Total Closed on Same Date =CALCULATE(COUNTROWS(dTicket); FILTER(dTicket; AND(dTicket[Created_Date]<=MAX(dCalendar[Date]);dTicket[Created_Date]>=MIN(dCalendar[Date])));FILTER(dTicket; AND(dTicket[Closed_Date]<=MAX(dTicket[Created_Date]);dTicket[Closed_Date]>=MIN(dTicket[Created_Date]))))
I think this problem there is no solution I tried everything if someone can help me I'll apreciate!