Forum Discussion
Filter the tickets which have the same opened/closed date
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]))))
Super Usernti-cristiano if I understood it correctly you can do something like this
Add following column
Same Day Close Flag = IF( Table[OpenDate] = Table[CloseDate], 1, 0 )
Add measure to get count of same day close
Total Closed on Same Day = SUM( Table[Same Day Close Flag] )
Hi parry2k ,
Thanks for the help! I just tested creating the column and the measure as you said but didn't work. I realized why, actually it just returns TRUE if the the dates (opened and closed) are exacly the same, like 07/02/2019 = 07/02/2019 equal TRUE, but what I need is to compare the dates using the table dCalendar clicking on the dates in the visual, the dCalendar can be used by month, day, year etc to filter the table dTicket. Example using dCalendar by month I need to know how many tickets were opened in the month and how many were closed in this same month.