Forum Discussion

ERIC_A's avatar
ERIC_A
Helper II
2 years ago
Solved

Ticket Open and Closed DistinctCount

Hello, I have the following Table  Ticket  Open Date Closed Date A 1/1/2023 1/1/2023 B 1/1/2023 1/1/2023 C 2/1/2023 2/1/2023 D 2/4/2023 2/1/2023   E 12/31/2022 1/1/...
Need Help
ERIC_A's avatar
ERIC_A
Helper II
2 years ago

hi Ashish thank you for your PBIX. your approach is interesting and is similar of what I did yesterday. 

here is how I solved it .

 

I created  a union table with the tickets and open date + tickets and closed date. 

Open+Closed = union(
SELECTCOLUMNS('Data',"Ticket",'Data'[Incident],"Date",'Data'[Tkt Crtn Date]),
SELECTCOLUMNS('Data',"Ticket",'Data'[Incident],"Date",'Data'[SolutionAppliedDate]))

 

and then I used this to obtain the distinct counts of tickets for a specific date.  

thank you for your response! 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    You are welcome.