Forum Discussion

nti-cristiano's avatar
nti-cristiano
Frequent Visitor
7 years ago
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...
Need Help
  • nti-cristiano's avatar
    nti-cristiano
    7 years ago

    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]))))

     

     

nti-cristiano's avatar
nti-cristiano
Frequent Visitor
7 years ago

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]))))

 

 

sreeni's avatar
sreeni
Frequent Visitor
7 years ago

Hi Cristanio, I'm facing the same problem as you have encountered. But I have applied the solution which you have given but data is not matching. If possible can you please share PBIX file or you can explain in detail.

Thank you.

SRRY.

nti-cristiano wrote:

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]))))